O'Reilly logo
  • Dustin Waybright thinks this is interesting:

comparing a NULL to anything yields unknown.

From

Cover of Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012

Note

If concerned about the order in which a predicate will be evaluated, make sure that the intended precedence order is not broken through a short-circuit by allowing for UNKNOWN like TRY_CAST.