This is what I do.

ex:

col1

1

2

3

4

5

6

declare @text varchar(500)

select @text = isnull(@text + ',','') + col1 from table1

select @text

Hope this help.