-- 查询语句，执行没问题。
declare @c varchar(100)
set @c = '1,2,3'
exec('select * from DyStfDir where StfJD in (' + @c + ')')

-- 判断语句，执行也没问题
if exists(select * from DyStfDir where StfJD in (1,2,3))
print 1111
else
print 2222

-- 想将@c放入exists()中就不行了。
declare @c varchar(100)
set @c = '1,2,3'
if exists('select * from DyStfDir where StfJD in (' + @c + ')')
print 1111
else
print 2222

请帮忙，多谢。

declare @c varchar(100)
set @c = '1,2,3'
if exists(select * from DyDir where charindex(cast(DyJD as varchar),@c)>0)
print 1111
else
print 2222