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

a NULL represents a missing value that could be applicable, and could be WA just like it could be anything else

From

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

Note

In a NE <> operand within the WHERE clause, NULL values are evaluated as unknown and not returned as true in the output.