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
