22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT lastName+(CASE
WHEN (ISNULL(lastName,'')<>'') AND ((ISNULL(middleName,'')<>'') OR (ISNULL(firstName,'')<>''))
THEN ',' ELSE ''
END)+middleName+' '+firstName
FROM TB
select fullName=lastName+','+ middleName+' '+ firstName from 表名
select lastName+','+middleName+' '+firstName as fullName from tb
select lastName+','+middleName+' '+firstName from tb