title: CASE statement with LIKE during LISTAGG Operation
body: <pre><code>+-----------+------------+-----------+-----------+
  | Person_ID | First_Name | Last_Name | Igroup_ID |
  +-----------+------------+-----------+-----------+
  |         2 | Rick       | Hudson    |       100 |
  |         2 | Rick       | Hudson    |        50 |
  |         2 | Rick       | Hudson    |        28 |
  |         2 | Rick       | Hudson    |        15 |
  |         3 | John       | Hardy     |       150 |
  |         3 | John       | Hardy     |       100 |
  |         4 | Tom        | Johnson   |       200 |
  |         4 | Tom        | Johnson   |       150 |
  |         4 | Tom        | Johnson   |       100 |
  +-----------+------------+-----------+-----------+
  </code></pre>
  
  <p>Please refer the above table the reason behind the usage of operation LISTAGG , I am getting Mutliple rows of Person ID since I have each person associated with multiple Group ID , So I wanted to Concatenate the Group ID using LISTAGG and seggregate the values.</p>
  
  <p>And since there are so many values IGROUP Values a each person can associate , But we worried about first 2 values , In the screenshot</p>
  
  <p>When something returns 100|50 Then 'GroupA'
  When something returns 150|100 Then 'GroupB'
  When something returns 200|150 Then 'GroupC'</p>
  
  <pre><code>(CASE LISTAGG(G.IGROUP_ID , '|') WITHIN GROUP (ORDER BY G.igroup_id) 
            WHEN  '100|50' THEN 'GroupA'
            WHEN  '150|100' THEN 'GroupB'
            WHEN  '200|150 THEN 'GroupC'
       END) AS SERVICES
  </code></pre>
  
  <p>But here the problem is if I use above way I have to define all the combinations in the CASE statement</p>
  
  <p>Is there any way I can use <code>WHEN LIKE '100|50%'</code> THEN GroupA</p>