Re: So what's null then if it's not nothing?

michael_at_preece.net wrote:
> I've been accustomed to thinking of things either having a value or
> not. If something has no value then, to me, its value is null.

A clear contradiction! If something has no value then it has no value.

> Its
> value is an empty string (whatever "it" is).

An empty string is a string like any other.

>Does SQL's definition of null (unknown) include the null
> I'm familiar with (no value)? That doesn't make sense. If we know
> something has no value then its not an unknown value is it?

Indeed, SQL nulls don't make sense. Nulls are a big mistake.

Regards
  Alfredo Received on Thu Nov 17 2005 - 11:59:07 CET