mike wrote:
I have the following query (I have removed all nulls from the field as
test)
SELECT first_name,work_email FROM tb_contacts WHERE
tb_contacts.work_email <>'';
However I get loads of blank email addresses coming up
anyone any ideas
A blank is never a NULL:
SELECT '' IS NULL;
?column?
----------
f
(1 row)
Try this:
SELECT first_name,work_email FROM tb_contacts WHERE
tb_contacts.work_email IS NOT NULL;
Or if there are also blanks among those e-mail addresses:
SELECT first_name,work_email FROM tb_contacts WHERE
tb_contacts.work_email IS NOT NULL AND tb_contacts.work_email != '';
--
Alban Hertroys
MAG Productions
T: +31(0)53 4346874
F: +31(0)53 4346876
E: [EMAIL PROTECTED]
W: http://www.magproductions.nl
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
