34,590
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM @tb WHERE CHARINDEX(',2,',','+context+',')>0
DECLARE @tb TABLE (context VARCHAR(20))
INSERT INTO @tb SELECT '1,2,3,4,5,7,11,12,22'
INSERT INTO @tb SELECT '1,3,4,5,7,11,12,22'
SELECT * FROM @tb WHERE CHARINDEX(',2,',context)>0