DECLARE @cond varchar(4000), @sql varchar(4000) SET @Cond = ' name like ''%John%'' ' SET @sql = 'SELECT * FROM customers where ' + @Cond EXECUTE (@sql)Check also How to return a value from dynamicaly executed T-SQL code FAQ #8130
>lcCond = " name like '%John%' " >SELECT * FROM customers where &lccond >>
>lcCond = " invoicenumber > 1056 " >SELECT * FROM invoices where &lccond >>