title: ORA-00939: too many arguments for function in CASE Statement
body: <p>I'm getting the <code>ORA-00939: too many arguments for function</code> error from my case statement.</p>
  
  <p>I have tried splitting it up into multiple <code>CASE</code> statements but still get the same error.</p>
  
  <pre><code>CASE WHEN l.fridge_door_modela_id = 'II-SH' THEN 'IW' 
       WHEN l.fridge_door_modela_id = 'IIC-SH' THEN 'IW' 
       WHEN l.fridge_door_modela_id = 'CD' THEN 'RPFX' 
       WHEN l.fridge_door_modela_id LIKE 'EXCR%' THEN SUBSTR(fridge_door_modela_id, 0, INSTR(fridge_door_modela_id, 'EXCR'),1)
       WHEN l.fridge_door_modela_id LIKE 'EX%' THEN SUBSTR(fridge_door_modela_id, 0, INSTR(fridge_door_modela_id, 'EX'),1) 
       WHEN l.fridge_door_modela_id LIKE '%-%' THEN SUBSTR(fridge_door_modela_id, 0, INSTR(fridge_door_modela_id, '-'),1) 
       ELSE 'CHECK CODE' 
       END AS Division
  </code></pre>