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 6, 2005 at 6:55 pm

    #563371

    "COUNT(*), on the other hand, does not eliminate NULLs."

    Actually, COUNT(val) will always eliminate nulls, but * includes all fields in the table and by definition is not null and will not be eliminated from the count. 

    I also noticed I said

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

    Should have said

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