请教in的用法?

[blueroute]

字段type是个字符串,如'2,3,4,5'

我用
select * from tablename where '2' in (type)
每次只能查处type只为'2'的记录,不能包含'2,3,4'的记录

请教!

[GRLD8888]

select * from tb1 where charindex(name1,'2')=1

[peanutsun]

select * from tablename where type in ('2','3','4','5')

[liuzijing688]

select * from tablename where type like '%2%'
select * from tablename where charindex('2',type)>0

[vivianfdlpw]

select * from tablename where charindex(',2,',','+type+',')>0

[子陌红尘]

select * from tablename where charindex(',2,',','+type+',')>0

[xueguang]

没必要用in,可以以下方法:
select * from tablename where type like '%2%'
select * from tablename where charindex('2',type)>0

[joyco]

select * from tb1 where charindex(type,'2')=1