• I run your question with

    SET ANSI_NULLS ON and SET ANSI_NULLS OFF, and the result is same. I use SQL Server 2012

    ?

    hm

    ?

    Igor Micev,My blog: www.igormicev.com