I use microsoft SQL server 2000
I have a table of person names and I have the follwing SQL
SELECT FirstName FROM Names
This gives me one column with a row for each person.
Now I want the query to return only one row containing a comma seperated string of all the firstnames.
Is this possible?