Create Email List From SQL Developer Data

Question

I want to export a list of email addresses ready to be copy and pasted into a distibution list for an email.

The select statement is simple:

select user_email from user_list where other = 'Y'

What do I need to do to add an ';' to the end of each email?

Im looking to product: [email protected];[email protected]; ect

gbn · Accepted Answer · 2011-06-13 09:37:11Z

DECLARE @List varchar(max) SET @List = '' SELECT @List = @List + ';' + user_email FROM user_list WHERE other = 'Y' SET @List = SUBSTRING(@List, 2, 2000000000) SELECT @List

Ivo · Accepted Answer · 2011-06-13 09:31:11Z

0

select user_email,';' from user_list where other = 'Y'

answered Jun 13, 2011 at 9:31

Ivo

3,4465 gold badges35 silver badges56 bronze badges

Collectives™ on Stack Overflow

Create Email List From SQL Developer Data

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related