a NULL represents a missing value that could be applicable, and could be WA just like it could be anything else
- 3. Filtering and Sorting Data
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
In a NE <> operand within the WHERE clause, NULL values are evaluated as unknown and not returned as true in the output.
Share this highlighthttp://learning.oreilly.com/a/training-kit-exam/18758/