Basic CASE Statement Example

SELECT invoice_number, terms_id,

CASE terms_id

WHEN 1 THEN 'Net due 10 days'

WHEN 2 THEN 'Net due 20 days'

WHEN 3 THEN 'Net due 30 days'

WHEN 4 THEN 'Net due 60 days'

WHEN 5 THEN 'Net due 90 days'

END AS terms

FROM invoices