Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at> writes:
> Actually I am not sure whether the column = NULL syntax is even
> defined or allowed in SQL92
I've just checked, by reading the relevant paragraphs and studying the
BNF, and the standard says that any comparison of the form X <comp op>
Y is unknown if X or Y (or both) is NULL, including the case where
NULL is given as an explicit constant. So, SQL92 clearly demands that
"column = NULL" is UNKNOWN, never TRUE or FALSE.
-tih
--
The basic difference is this: hackers build things, crackers break them.