错误语句,else后面直接跟拼接函数concat的值
SELECT
(
CASE
WHEN (GroupIds IS NULL
OR GroupIds = '') THEN '9000'
ELSE concat(GroupIds , concat(',' , '9000'))
END )
FROM
Acc_Persons
WHERE
UniqID IN ('27c')
正确语句,else后面需要跟字符串,利用to_char转字符串
SELECT
(
CASE
WHEN (GroupIds IS NULL
OR GroupIds = '') THEN '9000'
ELSE to_char(concat(GroupIds , concat(',' , '9000')))
END )
FROM
Acc_Persons
WHERE
UniqID IN ('27c')