concatenate all fields into one text field

[Chumley40]

I am trying to do this. Take a table that returns one colum like this

bobby
suzi
debbie

I want to create one field from this that has
bobby,suzi,debbie

how do I write this?

 

[bborissov]

DECLARE @Test varchar(max) -- varchar(8000) if you use SQL Server 2000

SELECT @Test = ISNULL(@Test+',', '') + NameOfTheColumn
FROM YourTable

SELECT @Test

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[gmmastros]

Just to add to Boris's suggestion....

[tt][blue]
WHERE NameOfTheColumn > ''
[/blue][/tt]

This will filter NULLs (which may give incomplete results) and empty strings (which would lead to double commas).



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[Chumley40]

Thanks, works great!