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

[Michael Kleiser <mkl@xxxxxxxxxxx>]

Maybe other whitspace or non-printable-character.
Try:

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

mike wrote:

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