This is one I’ve been wanting to figure out for awhile and just never got around to it.

So you have a list like this:
Select email from emaillist
email1 @
email2 @
email3 @
email4 @
email5 @

I get a record for each email in the table.
What I want is: email1 @,email2 @,email3 @,email4 @,email5 @,etc.

Here’s SQL I found to do it:

Declare @Description varchar(4000)
select @Description = coalesce(@Description + ‘,’ , ”) + rtrim(email) FROM emaillist
select @Description

You can change the ‘,’ to ‘;’ or any character you want for that matter.