Re: So what's null then if it's not nothing?
Date: Mon, 21 Nov 2005 15:43:34 GMT
Message-ID: <GWlgf.1677$aA2.731_at_newsread2.news.atl.earthlink.net>
<michael_at_preece.net> wrote in message
news:1132524918.521873.311260_at_z14g2000cwz.googlegroups.com...
> > > For us Pickies it's easy - null is
> I do not treat a string that doesn't exist as equal to the empty
> > > equal to an empty string.
> string. A string that doesn't exist is not null. How can it be equal to
> anything, null included, if it doesn't exist? A null does exist though
> - as an empty string.
Once again, an SQL NULL is a marker indicating the absence of a value. If the value would have been a string, then an SQL NULL marks the non-existence of such a string.
An empty string is different: it's a string that contains no characters. In the world of characters, it's an empty container. In the world of character strings, it's just another value.
> I believe Pick's definition of null is the
> correct one. It makes perfect sense. No confusion. Unlike SQL's
> definition. Admit it.
what is Pick's definition of null?
>
> Mike.
>
Received on Mon Nov 21 2005 - 16:43:34 CET