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 +, mike
Did you try something like:
select first_name, work_email
FROM tb_contacts
WHERE tb_contacts.work_email !~ '^\\s$';
If this works, then you may want to do something like:
update tb_contacts set work_email=NULL where work_email ~ '^\\s$';
to "clean" the data and then use a trigger to do the same pro
>>anyone any ideas
> If yes you should you have to use.
>
> SELECT first_name,work_email FROM tb_contacts WHERE
> tb_contacts.work_email <>''
> AND
> tb_contacts.work_email IS NOT NULL;
>
See what happens with
SELECT first_name, work_email, LENGTH(COALESCE(work_email, ''))
FROM tb_contacts
W
[snip]
> Or if there are also blanks among those e-mail addresses:
>
> SELECT first_name,work_email FROM tb_contacts WHERE
> tb_contacts.work_email IS NOT NULL AND tb_contacts.work_email != '';
The "tb_contacts.work_email IS NOT NULL" clause is superfluous, the
other condition will evaluate to f
Try:
SELECT first_name,'['||work_email||']' FROM tb_contacts WHERE
tb_contacts.work_email <>'';
Maybe you have spaces?
On Wed, Feb 02, 2005 at 09:59:30AM +, mike wrote:
> I have the following query (I have removed all nulls from the field as
> test)
>
> SELECT first_name,work_email FROM tb
On Wed, 2005-02-02 at 11:26 +0100, Alban Hertroys wrote:
> mike wrote:
> > I have the following query (I have removed all nulls from the field as
> > test)
> >
> > SELECT first_name,work_email FROM tb_contacts WHERE
> > tb_contacts.work_email <>'';
> >
> > However I get loads of blank email addr
On Wed, Feb 02, 2005 at 09:59:30AM +, mike wrote:
> I have the following query (I have removed all nulls from the field as
> test)
>
> SELECT first_name,work_email FROM tb_contacts WHERE
> tb_contacts.work_email <>'';
>
> However I get loads of blank email addresses coming up
>
Maybe you ha
On Wed, 2005-02-02 at 11:31 +0100, Troels Arvin wrote:
> On Wed, 02 Feb 2005 09:59:30 +, 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 ide
mike wrote:
I have the following query (I have removed all nulls from the field as
test)
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
---(end of broadcast)
mike wrote:
Try this:
SELECT first_name,work_email FROM tb_contacts WHERE
tb_contacts.work_email IS NOT NULL;
Or if there are also blanks among those e-mail addresses:
SELECT first_name,work_email FROM tb_contacts WHERE
tb_contacts.work_email IS NOT NULL AND tb_contacts.work_email != '';
no diff
Is there a newline or carriage return in the "blank" emails?
Sean
On Feb 2, 2005, at 4:59 AM, mike wrote:
I have the following query (I have removed all nulls from the field as
test)
SELECT first_name,work_email FROM tb_contacts WHERE
tb_contacts.work_email <>'';
However I get loads of blank email
mike wrote:
I have the following query (I have removed all nulls from the field as
test)
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
A blank is never a NULL:
SELECT '' IS NULL;
?column?
--
On Wed, 02 Feb 2005 09:59:30 +, 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 co
13 matches
Mail list logo
