SELECT STUFF((SELECT ','+PlatformName FROM NA_AbilityPlatformBaseInfo FOR XML PATH('')),1,1,'') SELECT STUFF((SELECT ','+PlatformName FROM NA_AbilityPlatformBaseInfo FOR XML RAW(''),ELEMENTS),1,1,'')