Hi,

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

Why? The "=" operator in an UPDATE statement
doesn't mean "equals", it means "becomes".

Hence, FIELD <becomes operator> 5 or
FIELD <becomes operator> NULL

Sounds fine to me.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com