Getting Comma seperated string from data in an sql Table column

Declare @Var Varchar(10)
Select @Var = COALESCE(@Var+',' , ' ') + Col1 FROM Tab_Name
SELECT @Var

.
===============================================
The content of this message may contain the private views and opinions of the sender and does not constitute a formal view and/or opinion of the company unless specifically stated.

The contents of this email and any attachments may contain confidential and/or proprietary information, and is intended only for the person/entity to whom it was originally addressed. Any dissemination, distribution or copying of this communication is strictly prohibited.

If you have received this email in error please notify the sender immediately by return e-mail and delete this message and any attachments from your system.

Please refer to http://www.newmont.com/en/disclaimer for other language versions of this disclaimer. ================================================