Like Query..

Question

Hi,

 

 I want to convert this query into like query.

 

SET @sqltext ='Select '+@field+' from '+@table+' where '+@wherefield+'='''+@whereval+''' And IsActive=1' 

 

how can I do this?