Hi,

I want to concatenate row values in a table using select statement in MS SQL.
For. e.g

Sl. Name
-- ------
1 Jack
2 Paul
3 Philip

Using a select statement we should get the following output.
Jack,Paul,Philip

can anyone tell me is it possible?

Thanks

__________________
The OXYGEN
Delivers edgy, intelligent Technology to all...

hi.. oxy....


yeah.. its possible

Please try the following query


Here I followed 2 steps for concatenating row values...

First, we can get the result using "for xml raw"
then, we convert it as varchar...

declare @cols varchar(1000)

select @cols = CAST ((select filedname as col1 FROM tablename
for xml raw, elements, type).query('for $col1 in (row/col1)
return concat($col1, ",")') as varchar(1000))

select @cols


I hope it will help you