• 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!