Cacher is the code snippet organizer for pro developers

/*UPDATE EMPLS ALIAS*/
UPDATE employee_profile
SET ms_alias = (
  CASE
    WHEN (title LIKE 'Manager%')
    THEN SUBSTR(first_name,1,1)
      || SUBSTR(last_name,1,4)
      || '_MGR'
    WHEN (title LIKE 'Medical Assistant%')
    THEN SUBSTR(first_name,1,1)
      || SUBSTR(LAST_NAME,1,5)
      || '_MA'
    WHEN (title LIKE 'Sec 3%')
    THEN SUBSTR(first_name,1,1)
      || SUBSTR(last_name,1,4)
      || '_SEC'
    WHEN (title LIKE 'Supervisor%')
    THEN SUBSTR(first_name,1,1)
      || SUBSTR(last_name,1,4)
      || '_SUP'
    WHEN (ms_alias IS NULL)
    THEN SUBSTR(first_name,1,1)
      || SUBSTR(last_name,1,8)
    ELSE ms_alias
  END )
WHERE UNIT_ID='&UNIT_NAME'
AND DEPT     ='891';