SQL-Server :Example of COALESCE

To bring the Multiple Column in to single column using comma separator:

declare @var varchar(800)
select @var=COALESCE(@var +',', '')+ CAST( AS varchar(250)) from
print @var