Re: UNIQUE and NULL in SQL

On Mon, 31 Dec 2001 16:51:03 GMT, "David Cressey" <david_at_dcressey.com> wrote:

>Where I would take issue with you is when you call "Not Applicable" a
>"value". It isn't a value, IMHO. It's a conclusion drawn from the fact
>that a value is not present at a given intersection of a row and a column.
>
>And I would maintain that NULL is never a value, regardless of the
>conclusion drawn from it. And I would further maintain that this is not a
>matter of opinion, but a matter of definition.
>

Agreed. Now how do we explain that to those who think null is a value?

-- 
Mark A. Preston, The Magpie's Nest, Lancashire, UK
Email   : mark_at_magpiesnest.co.uk
Website : www.magpiesnest.co.uk