Hi,

Try the code given below.

DECLARE @filterCriteria varchar

DECLARE @filterCMD varchar

declare @sql1 nvarchar(200)

set @filterCriteria = 'w'

IF @filterCriteria LIKE 'W'

set @filterCMD=' DESCRIP LIKE ''%closed%'' or DESCRIP LIKE ''%deny%'' or DESCRIP like ''%withdrawn%'' '

set @sql1='select accountID from TEMP_TABLE WHERE ' + @filterCMD

exec sp_executesql @sql1

Hope this solves the issue.

Nivedita Sundar.N