How to substitute Purchase for 'P' and 'Manufacturing' for 'M' and default 'Administration' for ' '(blank) in SQL/400 SELECT statement.
A CASE statement can be used in a SELECT statement to achieve this. Here is an example:
SELECT EMPNO, LASTNAME, FIRSTNAME, CASE EMP_DIV WHEN 'H' then 'Human_Resource' WHEN 'I' then 'Information_tech' WHEN 'P' then 'Purchase' WHEN 'M' then 'Manufacturing' ELSE 'ADMINISTRATION' END AS DIVISION FROM EMPLOYEE;
EMP_DIV can be replaced with SUBSTR expression to include part of String in field EMP_DIV.