22,302
社区成员




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