Concatenate names from all all the rows to one column

[member27]

Hi all, I want to get concatenatenames of all rows in one column ..can any one help me. suppose i get A B C AS 3 3 DIFFERENT ROWS I WANT TO CONCATENATE GET ABC AS THE RESULT = NEW COLUMN.. CAN ANY ONE CAN HELP

[Wendelius]

An easy way would be writing a stored procedure, opening a cursor on the table, loop through it and while looping, concatenate the return string.

The need to optimize rises from a bad design.My articles[^]

[Khawar Abbas1]

You can use COALESCE function of sql server for this purpose.

Do good and have good.

[Rob Philpott]

Something like this:

create table #X
(
C char(1)
)

insert into #X values ('A')
insert into #X values ('B')
insert into #X values ('C')

declare @z as varchar(2000)
set @z = ''

select @z = @z + C from #X

select @z

drop table #x

yields: ABC

Regards, Rob Philpott.

[Rob Philpott]

You reckon? How exactly?

Regards, Rob Philpott.

[member27]

Thank u verymuch it worked fine...

[Mycroft Holmes]

I hate cursors so I love this concat function DECLARE @Text VARCHAR(8000) SET @Text = '' SELECT @Text = @Text + ',' + class FROM PFClass SELECT @Text

Never underestimate the power of human stupidity RAH

[Jon_Boy]

Agreed......much rather use WHILE EXISTS(

Any suggestions, ideas, or 'constructive criticism' are always welcome. "There's no such thing as a stupid question, only stupid people." - Mr. Garrison

[Wendelius]

Yeah, also thought it was neat.

The need to optimize rises from a bad design.My articles[^]