timmitchell.net
T-SQL Quirk: Using NOT IN With NULL Values - Tim Mitchell
There is a little quirk in T-SQL with NULLs when using the NOT IN qualifier. I use the term “quirk” loosely here because the behavior is exactly as intended, though it may not be obvious. The following query shows a trivial example: At first glance, one might think that we’ll see returned the row for the Chevy MINIVAN. However, when...