On Mon, 17 Sep 2001, Tod McQuillin wrote:
> On Sun, 16 Sep 2001, Kovacs Baldvin wrote:
>
> > select NULL = NULL;
> >
> > The answer is: true!!!
>
> This has got to be a bug. NULL is not equal to anything (nor is it
> unequal to anything).
This is because of a hack due to a broken MS client that provided
=NULL for IS NULL in some (possibly small) case. There's a grammar
hack which makes the token sequence = NULL into IS NULL. There's
been talk about making this optional or ripping it out entirely (yay),
see past discussions on this topic for more detail.