numerous varchar columns in one row

Let's see if I understand.  You have a table like this:

Name, PhoneNumber, Email1, Email2, Email3

Select all Open in new window

and you want it to return like this?:

Bob,555-1212,bob@mail.com
Bob,555-1212,bob@gmail.com
Bob,555-1212,bob@yahoo.com

Select all Open in new window

That would look like this:

SELECT name,phoneNumber,email1
UNION ALL
SELECT name,phoneNumber,email2
UNION ALL
SELECT name,phoneNumber,email3
FROM sometable
WHERE name = 'Bob'

Select all Open in new window