On Wed, Feb 02, 2005 at 09:59:30AM +0000, 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 have some entries in the work_email column set to one or
more spaces.
--
Chris Green (chris(at)areti(dot)co(dot)uk)
"Never ascribe to malice that which can be explained by incompetence."