"Lew" <[EMAIL PROTECTED]> writes:
> Where NULL differs is that (NULL = NULL) is FALSE, and (NULL != NULL) is
> FALSE.
No, that's not true. NULL=NULL is NULL. And NULL!=NULL is NULL as well. Ie,
it's exactly as your table describes.
The confusion comes because WHERE clauses treat NULL the same a
Richard Huxton wrote:
PFC wrote:
NULL usually means "unknown" or "not applicable"
Andrew Sullivan wrote:
Aaaargh! No, it doesn't. It means NULL. Nothing else.
If it meant unknown or not applicable or anything else, then
SELECT * FROM nulltbl a, othernulltbl b
WHERE a.nullcol =
