日期:2014-05-17 浏览次数:20476 次
create table t1 ( a1 varchar(20) ) insert into t1 select '1,2,3,4,5' union all select '2,3,4,5,6' union all select '5,7,8,9,0' union all select '11,34,234,52' union all select '3,6,8,9' select * from t1 select * from t1 where LEN(a1)-len(REPLACE(a1,'3',''))>0
------解决方案--------------------
select * from t1 where LEN(a1)-len(REPLACE(a1,'3',''))>0