not null vs != OR <>

NULL Cannot be compared to any value using the comparison operators. NULL = NULL is false. Null is not a value. The IS operator is specially designed to handle NULL comparisons.



<> is Standard SQL-92; != is its equivalent: Both evaluate for values,
WHERE NULL CANNOT