title: use LIKE inside CASE/THEN in Oracle?
body: <p>I have this part of the code</p>
  
  <pre><code>WHERE p.id = m.id AND (
        CASE
          WHEN (c.match_text IS NOT NULL)
          THEN (
            (lower(p.station) LIKE '%'||c.match_text||'%')
            OR
            (
              (lower(p.station) LIKE '%sealed in%')
              AND
              (lower(p.affected_units) LIKE '%'||c.match_text||'%')
            )
          )
          WHEN(u.name LIKE '%Memory%')
          THEN (
            (lower(p.affected_fuels) LIKE '%nuclear%')
            AND
  </code></pre>
  
  <p>I get error with LIKE in this (lower(p.station) LIKE '%'||c.match_text||'%')!!</p>
  
  <p>why is that?</p>
  
  <p>I was thinking this approach will fix the issue:</p>
  
  <pre><code>WHEN (c.match_text IS NOT NULL)
  THEN (
    CASE WHEN
      (lower(p.station) LIKE '%'||c.match_text||'%')
      OR
      (
        (lower(p.station) LIKE '%sealed in%')
        AND
        (lower(p.affected_units) LIKE '%'||c.match_text||'%')
      )
      THEN true
      ELSE false
      END
  )
  </code></pre>
  
  <p>Thanks</p>