title: Oracle Case When Like
body: <p>I have the following code:</p>
  
  <pre><code>case when (a.je_source='Revaluation') then 'No_Location' 
      when d.user_name like ('SCHE%') then 'No_Location' 
      when d.user_name like ('C-FA%') then 'No_Location' 
      when d.user_name like ('C-AGO%') then 'No_Location'
      when d.user_name like ('C-VD%') then 'No_Location'
      when d.user_name like ('C-JL%') then 'No_Location'
      else d.user_name  
  end as JE_User
  </code></pre>
  
  <p>Is there a way to make it cleaner?  I tried the following and received a missing right parenthesis error.</p>
  
  <pre><code>case when (a.je_source='Revaluation') then 'No_Location'
      when d.user_name like ('SCHE%', 'C-FA%') then 'No_Location' 
      else d.user_name 
  end as JE_User
  </code></pre>