Hi Alan,

> I always know that you can't compare NULL to anything but I must say
> it's just a little ambiguous to have say
> update table set field=NULL
> instead of
> update table set field to null
> As infrequently as I use this statement, I find myself writing the
> latter and having to correct myself to the former.

Totally agree! For comparison you must use "is null" so for assignment
it should have been "to null". I've ranted about this before.

But it's SQL standard so I think we're stuck with it...


Greetings,
Paul Vinkenoog