Hi,

I have a contact info table that has two emails columns (email1 & email2). I'd like to return a list of all existing emails, whether it be in email1 or email2.

Any ideas how I can do this?

Thanks,

Michael

use a UNION ALL query, with two SELECTs

if either can be null, use a WHERE condition in that SELECT