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