Learn the differences ... Is Null and IsNull() both find null values, but you won’t use them in the same way. You would use Is Null and Is Not Null in query expressions and SQL WHERE clauses.