dynamic Query sql

alter Procedure Search
@strSearch VarChar(100)

AS
Declare @SQL VarChar(1000)

Select @SQL = 'SELECT * FROM ASSET_MASTER '
Select @SQL = @SQL + @strSearch
Exec ( @SQL)

GO

exec search 'where ASSET_NAME like ''monit%'''