Re: When is a blank not a null or ''

SELECT first_name, '[' || work_email || ']', ASCII(work_email) FROM tb_contacts  WHERE
tb_contacts.work_email <>'';

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@postgresql.org