Re: NULL value EQUALS to EMPTY string?!

From: TurkBear <johng_at_mm.com>
Date: Mon, 07 Feb 2000 18:31:57 GMT
Message-ID: <38a00e0b.9949496@204.181.81.99>

Furthermore,
Nothing is equal to NULL ( That is, no thing, not the quantity nothing) not even NULL the only operators for use with NULL are IS and NOT IS

select x from y where z is null; or
select x from y where z is not null;

---

When inserting, a empty string '' is considered NULL, a blank string ' ' is a blank string that can be selected or excluded with standard Sql syntax...

select x from y where z <> ' ';
select x from y where z = ' ';
select x from y where z > ' ';
..etc.

all work on blank strings, but not for empty (NULL) strings...

Just more to think about,
John G

"Michel Cadot" <micadot_at_netcourrier.com> wrote:

>Your statements show it to you:
>empty string is NOT equal to null,
>empty string IS null.

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Mon Feb 07 2000 - 12:31:57 CST