databasessqltips
SQL null checks need their own predicate
Anonymous
In SQL, x = null does not evaluate to true; comparisons with null yield unknown. Use x is null to test for null. In a where clause, only true rows pass, so a null comparison may filter rows even when no explicit error occurs.
0