34,588
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM DAT_SUM
WHERE C_CODES LIKE '%1%' OR C_CODES LIKE '%3%' OR C_CODES LIKE '%12%'
select * from dat_sum
where charindex(',1,', ','+c_codes+',') >0
or charindex(',2,', ','+c_codes+',') >0
or charindex(',12,', ','+c_codes+',') >0;
select * from dat_sum
where charindex(',1,',','+c_codes+',')>0
or charindex(',3,',','+c_codes+',')>0
or charindex(',12,',','+c_codes+',')>0