Re: [GENERAL] When is a blank not a null or ''

Wed, 02 Feb 2005 08:29:16 -0800

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 [EMAIL PROTECTED]

Reply via email to