Hi,
U can declare a variable & and use "coalesce" or "ISNULL".
U can get in Comma seperated by using "coalesce" or "ISNULL"
Declare @var Varchar(MAX)
CREATE Table #temp (id int identity(1,1),Name VARCHAR(10))
INSERT INTO #temp
Select 'a' UNION
Select 'b' UNION
Select 'c' UNION
Select 'd' UNION
Select 'e' UNION
Select 'f' UNION
Select 'g' UNION
Select 'h'
Select @var=ISNULL(@var,'')+Name+' , ' from #temp order by
SELECT @var
Regards,
Pulivarthi Sasidhar