SQL语法问题

Question

有一个变量是a= '1,2,3,4,5'select * from tb1 where aa in(@a)怎么让语句的效果是select * from tb1 where aa in('1','2','3','4','5')

Answer 1

select * from tb1 where charindex(','+aa+',',','+a+',')>0

Answer 2

select * from tb1 where charindex(','+ltrim(aa)+',',','+a+',')>0

Answer 3

http://www.yongfa365.com/Item/PROCEDURE-IN-SQL-Server.html

Answer 4

declare @a varchar(20)
set @a= '1,2,3,4,5'
exec('select * from tb1 where aa in('+@a+')')

Answer 5

select * from tb1 where charindex(','+ltrim(aa)+',',','+a+',')>0