title: How to use Search multiple LIKE for IN condition in DB2
body: <pre><code>  SELECT *
    FROM XYZ
    WHERE column1 IN (X1,Y1,Z1);
  </code></pre>
  
  <p>I want to use <strong>LIKE</strong> with this select query; how can I write <strong>LIKE</strong> statement with <strong>IN</strong>, similar to the query as below:</p>
  
  <pre><code>  SELECT * 
    FROM XYZ 
    WHERE column1 LIKE IN  ($P{COLUMN});
  </code></pre>
  
  <p><strong>ANOTHER EXAMPLE:-</strong></p>
  
  <blockquote>
    <p>select * from ( select REPLACE(REFEV_VEH_TYPE, ' ', '') ||
    REPLACE(REFEV_CATEGORY, ' ', '') || REPLACE(REFEV_USAGE, ' ', '') ||
    REPLACE(REFEV_BODY_CODE, ' ', '') as  UC  from TREF_ENF_VEHICLE_TYPE )
    aa where   aa.UC  LIKE ('%06TBISUM%')</p>
  </blockquote>
  
  <pre><code>UC
  ------
  06TBISUM
  </code></pre>
  
  <blockquote>
    <p>select * from ( select REPLACE(REFEV_VEH_TYPE, ' ', '') ||
    REPLACE(REFEV_CATEGORY, ' ', '') || REPLACE(REFEV_USAGE, ' ', '') ||
    REPLACE(REFEV_BODY_CODE, ' ', '') as  UC  from TREF_ENF_VEHICLE_TYPE )
    aa where   aa.UC  LIKE ('%B')</p>
  </blockquote>
  
  <pre><code> UC
  ----------
  06TGISJB
  06TGITJB
  </code></pre>
  
  <blockquote>
    <p>select * from ( select REPLACE(REFEV_VEH_TYPE, ' ', '') ||
    REPLACE(REFEV_CATEGORY, ' ', '') || REPLACE(REFEV_USAGE, ' ', '') ||
    REPLACE(REFEV_BODY_CODE, ' ', '') as  UC  from TREF_ENF_VEHICLE_TYPE )
    aa where   aa.UC  LIKE ('%BAS')</p>
  </blockquote>
  
  <pre><code>UC
  ----------
  06BCIBAS
  05BCABAS
  05BCBBAS
  </code></pre>
  
  <p><strong>The result that i want to know is :</strong></p>
  
  <p>select * from (
  select REPLACE(REFEV_VEH_TYPE, ' ', '') || REPLACE(REFEV_CATEGORY, ' ', '') || REPLACE(REFEV_USAGE, ' ', '') || REPLACE(REFEV_BODY_CODE, ' ', '') as  UC 
  from TREF_ENF_VEHICLE_TYPE ) aa
  where   aa.UC IN LIKE (<strong>'%06TBISUM%', '%B','%BAS'</strong>).</p>
  
  <pre><code>UC
  ------
  06TBISUM
  06TGISJB
  06TGITJB
  06BCIBAS
  05BCABAS
  05BCBBAS
  </code></pre>
  
  <p>The parameter that i use is <strong>$P{COLUMN}</strong>.
  i want to search multiple by <strong>$P{COLUMN}</strong> parameter using IN LIKE($P{COLUMN}).Anyone know about this?</p>