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

comparing a NULL to anything yields unknown.


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


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.