Home Forums Article Discussions Article Discussions by Author Discuss content posted by Samith C NULL RE: NULL
honza.mf
SSCertifiable
Points: 5519
More actions
August 15, 2012 at 2:49 am
#1525912
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.+1Yes that's correct!
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.
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!
And even worse the answer is incorrect with ANSI NULLS off.