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

exec @ssql



还有一种玩法，没试过，先不说