Sql Server 2012 - Three-Valued Logic
From MyWiki
The type of logic used in such a
case is known as two-valued logic. The WHERE filter returns only the rows for which the predicate
evaluates to true
A predicate can evaluate
to true, false, and unknown. This type of logic is known as three-valued logic
when region is NULL, the predicate region <>
'WA' evaluates to unknown, and the row is discarded
