Home Forums Article Discussions Article Discussions by Author Discuss content posted by muzahm Understanding NULL RE: Understanding NULL

  • November 18, 2008 at 11:55 am

    #900120

    As rightly mentioned by Tao, try to run it with ANSI_NULLS OFF:

    set ansi_nulls off

    IF(NULL IN (34, 35, NULL))PRINT 'TRUE'

    IF(34 NOT IN (35, 36, NULL))PRINT 'FALSE'

    and you will get a completely different answer

    Regards,Yelena Varsha