Re: NULL with IN-Clause

From: Nils <nkp_at_pjc-corp.com>
Date: Tue, 11 May 1999 15:39:59 +0200
Message-ID: <UtWZ2.1011$Vo6.24322@news020.image.dk>

James Lorenzen <james_lorenzen_at_allianzlife.com> wrote in message news:7h9aab$v53$1_at_nnrp1.deja.com...
> A NULL is an unknown value. That means a NULL is never equal to
> anything, not even another NULL. It also means that a NULL is never not
> equal to anything. IE NULL = NULL evaluates to FALSE, therefore the IN
> clause with a NULL in the value list will never return a NULL value.
>
> BTW: NULL != NULL also evaluates to FALSE.
>

Shouldn't the result of NULL = NULL or NULL != NULL evaluate to NULL, since FALSE is as wrong as TRUE?

Nils Received on Tue May 11 1999 - 08:39:59 CDT