Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by James Travis Understanding the difference between IS NULL and = NULL RE: Understanding the difference between IS NULL and = NULL

  • June 3, 2005 at 4:36 pm

    #563028

    FYI sql like 'customerid = ' & sCustomerID

    Can be 'isnull(customerid) = isnull(' & sCustomerID & ')'

    or it can be '(customerid is null and ' & sCustomerID & ' is null) or customerid = ' & sCustomerID