I know that SQL's
WHEN search_condition THEN statement_list
[WHEN search_condition THEN statement_list] ...
CASE is more like a switch statement. It has two syntaxes you can use. The first lets you use any compare statements you want:
CASE WHEN user_role = 'Manager' then 4 WHEN user_name = 'Tom' then 27 WHEN columnA <> columnB then 99 ELSE -1 --unknown END
The second style is for when you are only examining one value, and is a little more succinct:
CASE user_role WHEN 'Manager' then 4 WHEN 'Part Time' then 7 ELSE -1 --unknown END