Advanced Databases - Simple Case Structure (SQL Server)
CASE input_expression
WHEN when_expression1 THEN value1
WHEN when_expression2 THEN value2
.
.
ELSE valueN
END
CASE input_expression
WHEN when_expression1 THEN value1
WHEN when_expression2 THEN value2
.
.
ELSE valueN
END