declare @Temp Table(Col int)

Insert into @Temp

Select 1

UNION Select 2

UNION Select 3

UNION Select 4

UNION Select 5

Select * from @Temp

Declare @coalesce varchar(200)

Set @coalesce=''

Select @coalesce=@COALESCE+Convert(varchar,Col)+',' from @Temp

Select @coalesce=left(@COALESCE,LEN(@COALESCE)-1)

Select @coalesce

Thanks!