How to get comma separated value..?

Question

My query is

select ContactId from dbo.ContactGroupReln where ContactGroupId=@ContactGroupId

through this query i want to get the comma separated list..Can any body help me pls..