search case

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

Syntax

CASE WHEN [Country] = 'Canada' THEN ([List Price] * 0.60) WHEN 
[CountryCode] > 100 THEN [List Price] * 0.80 
ELSE [List Price] END
Parent topic: Constructs