字符串的'1,2,3'转1,2,3

[jishengzu]

declare @a varchar(500)
set @a='';
select @a=@a+convert(varchar(5),id)+',' from Def_employee where id<10
print @a

select * from Def_employee where id in(@a)

怎么才能实现这语句呢select * from Def_employee where id in(@a)
把字符串的@a转换成可支持in(@a)

[jishengzu]

3q 3q 3q 3q

[永生天地]

select * from Def_employee where charindex(','+id+',',','+@a+',')>0

[黄_瓜]

select * from Def_employee where charindex(','+ltrim(id)+',',','+@a+',')>0

[永生天地]

declare @a varchar(500),@s varchar(1000)
set @a='';
select @a=@a+convert(varchar(5),id)+',' from Def_employee where id<10
print @a

set @s='select * from Def_employee where id in('+@a+')'
exec(@s)

[东那个升]

直接select * from Def_employee where id<10不就可以了么