honza.mf (8/15/2012)
Lokesh Vij (8/14/2012)
rVadim (8/14/2012)
I think any comparison against NULL will yield Unknown, which is not True, and therefore records won't be returned.
+1
Yes that's correct!
+1
And even worse the answer is incorrect with ANSI NULLS off.
I did spend some time checking to see if there were any clues as to whether ANSI NULLS was on or off before I answered!