Re: IS NULL against = NULL

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Fri, 10 Nov 2000 13:28:30 GMT
Message-ID: <3a0bf7be.862994359@news.alt.net>

On Thu, 9 Nov 2000 12:24:01 -0500, "Bob Boylan" <BobBoylan_at_prodigy.net> wrote:

>Wonder why the "= NULL" isn't flagged as an error? I've been stung by this
>in the past. Note that "=NULL" does work with sybase and also sqlserver!
>
>Go figure, Bob
>

I would guess because you can set a row to null that way, thus the expression is valid.

UPDATE table SET column = NULL;

Brian Received on Fri Nov 10 2000 - 07:28:30 CST