日期:2014-05-18 浏览次数:20405 次
select * from tb where patindex('%,2,%,','+col+',')>0
------解决方案--------------------
select * from tb where patindex('%,2,%,','+col+',')>0
------解决方案--------------------
where charindex(',2,',',' + col + ',') > 0
------解决方案--------------------
where patindex('%,2,%',',' + col + ',') > 0