Show column data in a comma separated single line.

Question

I have a table in SQL and table has one column(NAME) and the values are in NAME column as
A
B
C
...
...
...
X 
Y
Z

Then, I want to show data through SQL query in a single line like A, B, C, ..... X, Y, Z.

Anurag Singh