10 / 10

CASE Expressions

Simple vs searched CASE, default branch, common patterns.

What you’ll learn

Simple vs searched CASE forms; default branch.

-- Searched CASE
SELECT OrderID,
  CASE
    WHEN TotalDue >= 1000 THEN 'High'
    WHEN TotalDue >= 100  THEN 'Medium'
    ELSE 'Low'
  END AS Segment
FROM dbo.Sales;

-- Simple CASE
SELECT Code,
  CASE Code
    WHEN 'A' THEN 'Alpha'
    WHEN 'B' THEN 'Beta'
    ELSE 'Other'
  END AS Label
FROM dbo.Codes;

Notes

CASE returns the first matching branch.
Result type follows implicit conversions across branches; cast if needed.