i want to show this:
select * from table1 where field in ('aa','bb')

======================================
declare @vchr varchar(100)
set @vchr ='aa','bb'
select * from table1 where field in (@vchr)

running display error....
==================================================
if not use exec(@sql), how to express ？