SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—540440-003
9-19
Examples of CASE
HALL KATHRYN SYSTEM ANALYST
...
--- 62 row(s) selected.
•
Use a searched CASE to return LAST_NAME, FIRST_NAME and a value based
on SALARY that depends on the value of DEPTNUM:
SELECT last_name, first_name, deptnum,
CASE
WHEN deptnum = 9000 THEN salary * 1.10
WHEN deptnum = 1000 THEN salary * 1.12
ELSE salary
END
FROM persnl.employee;
LAST_NAME FIRST_NAME DEPTNUM (EXPR)
---------------- ------------ ------- -------------------
GREEN ROGER 9000 193050.0000
HOWARD JERRY 1000 153440.1120
RAYMOND JANE 3000 136000.0000
...
--- 62 row(s) selected.