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).
--
Greetings from Troels Arvin, Copenhagen, Denmark
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
