sql 字符串叠加

SELECT (CONVERT(varchar(5),PID) + ',' + ValueNo) AS PID, Name  FROM tbItemClass  WHERE (FID = '101') AND (PID <> '101')    ORDER BY FID, SN