• 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