SELECT *
FROM Cmp_Notice
WHERE
CASE WHEN FirstName IS NOT NULL
THEN LastName like '%AA%'
ELSE FirstName like '%AA%'
END
-----------
如以上查询语句执行出错
--------------------------------------
那正确的要怎么写
我要的是
当FirstName为null的时候LastName要包含AA,
当FirstName不为null的时候FirstName包含AA谢谢
FROM Cmp_Notice
WHERE
CASE WHEN FirstName IS NOT NULL
THEN LastName like '%AA%'
ELSE FirstName like '%AA%'
END
-----------
如以上查询语句执行出错
--------------------------------------
那正确的要怎么写
我要的是
当FirstName为null的时候LastName要包含AA,
当FirstName不为null的时候FirstName包含AA谢谢
SELECT *
FROM Cmp_Notice
WHERE (FirstName IS NOT NULL and FirstName like '%AA%') or
(FirstName IS NULL and LastName like '%AA%')
SELECT *
FROM Cmp_Notice
WHERE (FirstName IS NOT NULL and FirstName like '%AA%')
union all
SELECT *
FROM Cmp_Notice
WHERE (FirstName IS NULL and LastName like '%AA%')
FROM Cmp_Notice
WHERE FirstName IS NOT NULL and FirstName like '%AA%'
union all
SELECT *
FROM Cmp_Notice where
FirstName IS NULL and LastName like '%AA%'
但是这样Where条件不是很直观,有没有Case When的方法
谢谢
FirstName is null and LastName like '%AA%' or
FirstName is not null and FirstName like '%AA%'
(FirstName is null and LastName like '%AA%') or
(FirstName is not null and FirstName like '%AA%')