Paul,

>> 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.

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

Not sure I agree. The only problem I see is that the "=" symbol is
overloaded as both equality and assignment operator. "assign NULL to a
field" (hence using the assignment operator) looks more consistent to
me than inventing a different syntax just for nulls.

Ciao
--
Nando mailto:nandod@...