Two shorthand forms of CASE are provided to handle nulls: COALESCE is described under “COALESCE Expression”. NULLIF is described under “NULLIF Expression”.