Hi,

I have one senario. I have to merge more than one row into a single column.

Say for example,

create table #t1
(
no char(1)
)

insert into #t1
select '1'
union
select '2'
union
select '3'
union
select '4'


Declare @no varchar(25)
select @no = ''
select @no = @no + no
from #t1
select @no

is there any other way to do the same task ?

Inputs are welcome !