SELECT a CASE isnull(a, '') WHEN '' THEN b ELSE a END FROM tblA WHERE ((isnull(a, '') <> '') OR (isnull(b, ''))运行说是在关键字 CASE附近有语法错误
写错了你: 是SELECT a=CASE.....
SELECT a = CASE WHEN isnull(a, '') LIKE '' THEN b ELSE a END FROM tblESITitle WHERE ((isnull(a, '') NOT LIKE '') OR (isnull(b, '') NOT LIKE ''))搞定,谢谢邹建兄和小儿兄!
给点数据,和你想要的结果,好测试
WHEN '' THEN b ELSE a END
FROM tblA
WHERE ((isnull(a, '') <> '') OR
(isnull(b, ''))运行说是在关键字 CASE附近有语法错误
是SELECT a=CASE.....
FROM tblESITitle
WHERE ((isnull(a, '') NOT LIKE '') OR
(isnull(b, '') NOT LIKE ''))搞定,谢谢邹建兄和小儿兄!