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

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(at)postgresql(dot)org
>
>