Quote:
Originally posted by Krutsinger
The case statement in question was:
select
(case when name like '%CG ANT%' then 'Ant' else
(case when name like '%CG GP%' then 'Group' else
(case when name like '%CGC%' then 'Cutter' else
(case when name like 'CG STA%' then 'Station' else
(case when name like '%ACT%' then 'Activity' else
(case when name like 'CGD%' then 'Districts' else
(case when name like '%BASE%' then 'Base' else
'Other' end) end) end) end) end) end) end) AID_UNIT_TYPE
from x;
First of all, I even don't like the way you wrote your CASE expression - you have nested 6 CASE expressions one into another, while you could use a single case statement. Remember, CASE does not provide you only with IF-ELSE-END logic, it also enables you to write IF-ELSIF-ELSIF...-ELSE-END logic. So your select should rathere look like: