Re: Character Equality

From: Caffeine <danny_milne_at_yahoo.co.uk>
Date: Wed, 13 Sep 2000 11:12:13 GMT
Message-ID: <8pnne2$7p9$1@nnrp1.deja.com>

Thanks very much for you help. Problem solved.

In article <39BE6821.87F19975_at_lambic.co.uk>, Mark <cdo_at_lambic.co.uk> wrote:
> Caffeine wrote:
> >
> > Hi there,
> > Just wondering if any one can explain to me why the following
> > statement returns no rows.
> >
> > select test from tmp4 where test != '';
>
> '' is equivalent to NULL, and you cannot do equality comparisons with
> NULL, instead do:
>
> select test from tmp4 where test IS NOT NULL;
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Sep 13 2000 - 06:12:13 CDT