SELECT  SUBSTRING（
（ SELECT  ' ，' + RTRIM（MyColumn） FROM  myTable 
 FOR  XML PATH（' '））， 2 ， 100000 ） AS  CSV 

Hi all,

I have a column and having values are as:-
column
ABC
XYZ
LKO
TEMP

I want result as ABC,XYZ,LKO,TEMP.

thanks & Regards
Mohd Wasif

SELECT SUBSTRING(
(SELECT ',' + RTRIM(MyColumn) FROM myTable
FOR XML PATH('')),2,100000) AS CSV