34,593
社区成员
发帖
与我相关
我的任务
分享
DECLARE @t TABLE(a01 INT NOT NULL,a02 VARCHAR(100) NULL)
INSERT @t(a01, a02)
VALUES(1,'1'),(1,'1,2'),(1,'1,2,3'),(2,'1,2 '),(2,'1,2,3'),
(2,'2,3 '),(2,'3'),(3,'1,2,3'),(3,null),(3,'1,2')
SELECT * FROM @t WHERE CHARINDEX(CAST(a01 AS VARCHAR(10)),COALESCE( a02,''))=0