Alan,

A> What about having a way to test:
A> IF Field=NULL then

Fb2 has it already, in the "is [not] distinct from" operator, which is
standard-compliant. In my view that's an example of listening to
feature requests with the added grain of salt of implementing the
feature in a standard-compliant way. I support this.

BTW, other databases that allow the expression (null=null) to be true
either aren't ANSI compliant or have a session-level switch to enable
it (like MS-SQL's SET ANSI NULLS).

Ciao
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================