Home Forums Article Discussions Article Discussions by Author Discuss content posted by Bhuvnesh Play with NULLIF RE: Play with NULLIF

  • May 3, 2010 at 10:09 am

    #1161372

    Paul White NZ (5/3/2010)

    Hugo Kornelis (5/3/2010)

    Using ISNULL can work around this - although the result is admittedly not trivial to understand:

    AND NULLIF(Column1, Column2) IS NULL

    AND NULLIF(Column2, Column1) IS NULL

    :w00t: Hugo!!! Yuk! :sick:

    :Whistling:

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/