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

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)