CASE and Nulls - Teradata VantageCloud Lake

The ANSI SQL:2011 standard specifies that the CASE expression and its related expressions COALESCE and NULLIF must be able to return a null result.

• Nulls and CASE Expressions
• COALESCE Expression
• NULLIF Expression