Stewart "Arturius" Campbell (7/1/2015)
Is NULL=NULL true ?
NULL != NULL or anything else.
NULL is actually a reflection of the state of the field, i.e. there is no value assigned to it.
This is where playing aound with SET ANSI_NULL delivers some interesting results...
Yes, my question and answer assume ANSI_NULL is set on; that is the default situation for sQL Server, and the ability to set it off has been deprecate for a very long time and will soon be unavailable. Any comparison involving NULL (either as both arguments or as one f them) delivers UNKNOWN - not TRUE, and not FALSE.