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 10:53 pm

    #563055

    "Select Count(Field1) Where Field1 Is Null" DOES return the number of records that have a Null value for that field, regardless ofthe ANSI Nulls setting.

    No, it does not.  SELECT COUNT(column1) eliminates NULL values, per the ANSI-92 definition.  SELECT COUNT(*) does not.