ANSI also defines two shorthand special cases of CASE specifically for handling nulls.
- COALESCE expression (see COALESCE Expression)
- NULLIF expression (see NULLIF Expression)