Null Expressions in Comparisons - Teradata Vantage

If any expression in a comparison is null, the result of the comparison is unknown.

For a comparison to provide a TRUE result when comparing fields that may result in nulls, the statement must include the IS [NOT] NULL operator.