hi Arup,

you can use the following code to get comma saperated data in a cell.

declare @Column1 varchar(8000)

set @Column1=''

select @Column1=@Column1+','+convert(varchar,Column1) from Table1

select substring(@Column1,2,len(@Column1))

Thanks & Regards

Rakesh Singh