CASE expression

Applies to: sql

A SQL CASE expression creates conditional values inside a query, similar to if logic.

CASE WHEN score >= 90 THEN 'A' ELSE 'B' END

See also: conditional, select