如何匹配这样的字段？

[fromgx]

例如 有某字符串字段，内容为： 1,2,13,4,22,33,12,2213,2223

给定其中一个数字，Where 中 如何匹配这个字段呢？

[ws_hgo]

select * from tb where charindex('1,2,13,4,22,33,12,2213,2223',col)>0

[百年树人]

declare @i int
set @i=1
select * from tb where charindex(','+ltrim(@i)+',',','+字段+',')>0

[水族杰纶]

select * 
from tb 
where charindex(','+ltrim(@num)+',',','+col+',')>0

[ACMAIN_CHM]

charindex

[叶子]

declare @col varchar(60)
set @col='1,2,13,4,22,33,12,2213,2223'
declare @i varchar(6)
set @i='6'

if(charindex(','+ltrim(@i)+',',','+@col+',')>0)
select '存在'
else
select '不存在'