590
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM tab1 t
WHERE t.flag=1 AND t.colum1='003'
UNION ALL
SELECT * FROM tab1 t
WHERE t.flag!=1 AND t.colum1 IN('001','002')
SELECT *
FROM tab1 t
WHERE ( CASE WHEN t.flag = 1 THEN CHARINDEX(t.colum1, '003')
ELSE CHARINDEX(t.colum1, '001,002')
END ) > 0;