T-SQL provides the predicate IS NULL to return a true when the tested operand is NULL
- 3. Filtering and Sorting Data
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
Would need to add ISNULL in an OR statement to return NULL rows.
Share this highlighthttp://learning.oreilly.com/a/training-kit-exam/18759/