CASE Rules

Learn the rules of the SQL CASE statement — it must end with END, compatible THEN types, optional ELSE, evaluation stopping at the first match, nesting, NULL comparisons, where it can appear, and pitfalls.