34,576
社区成员
发帖
与我相关
我的任务
分享
with t(ID,字段A) as
(select 1,N'A-1,A-13,A-15' union
select 2,N' A-13,A-15' union
select 3,N' A-1,A-15')
select * from t where charindex(N'A-15,',字段A+N',')<>0
这样试试SELECT *
FROM table1
WHERE CHARINDEX(N'A-1,',
REPLACE(字段A,N',',N',') + N','
) <> 0
with t(ID,字段A) as
(select 1,'A-1,A-13,A-15' union
select 2,' A-13,A-15')
select * from t where charindex('A-1,',字段A)>0
SELECT *
FROM table1
WHERE CHARINDEX(N'A-1,', 字段A+N',') <> 0