simple case

This construct is the template for a simple case, including the CASE, WHEN, ELSE, and END functions.

Syntax

CASE [Country] WHEN 'Canada' THEN ([List Price] * 0.60) WHEN 
'Australia' THEN [List Price] * 0.80 
ELSE [List Price] END