On Wed, 2005-02-02 at 11:31 +0100, Troels Arvin wrote: > On Wed, 02 Feb 2005 09:59:30 +0000, mike wrote: > > > 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 > > An idea: You have " "-values in your work_email column, i.e. work_email > values consisting of space(s). > nope SELECT work_email FROM tb_contacts WHERE tb_contacts.work_email ILIKE '% %'; work_email ------------ (0 rows) ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
