title: easier way to do multiple substr instr OR statements oracle pl sql
body: <p>I want to check every 2 positions of a table column for many different values. (selecting any row that matches any specified value in any of the 2 digit positions)
  This is the only way I know of to do what I need, but I bet there is a cleaner, shorter way:</p>
  
  <pre><code>select *
  from table
  where 1=1
  and (      
  Substr(columnA,1,2)  IN ('CE','44','45','87','89','UT','AZ','XX','YY','S1','S2','S3','S4','ES','PM')
                          or Substr(columnA,3,2)  IN ('CE','44','45','87','89','UT','AZ','XX','YY','S1','S2','S3','S4','ES','PM')
                          or Substr(columnA,5,2)  IN ('CE','44','45','87','89','UT','AZ','XX','YY','S1','S2','S3','S4','ES','PM')
                          or Substr(columnA,7,2)  IN ('CE','44','45','87','89','UT','AZ','XX','YY','S1','S2','S3','S4','ES','PM')
                          or Substr(columnA,9,2)  IN ('CE','44','45','87','89','UT','AZ','XX','YY','S1','S2','S3','S4','ES','PM')
                          or Substr(columnA,11,2) IN ('CE','44','45','87','89','UT','AZ','XX','YY','S1','S2','S3','S4','ES','PM')
                          or Substr(columnA,12,2) IN ('CE','44','45','87','89','UT','AZ','XX','YY','S1','S2','S3','S4','ES','PM')
                          or Substr(columnA,14,2) IN ('CE','44','45','87','89','UT','AZ','XX','YY','S1','S2','S3','S4','ES','PM')
                          or Substr(columnA,16,2) IN ('CE','44','45','87','89','UT','AZ','XX','YY','S1','S2','S3','S4','ES','PM') )
  ;
  </code></pre>
  
  <p>note: if the column's value is ABCDEF, and we are checking for 'BC', this should not find a match, only 'AB', 'CD', 'EF' should match. </p>
  
  <p>I want to be able to list everything I am searching for just once. Even better would be to only list columnA once.
  I did find an INSTR function that may be useful, but I'm not sure how to apply it here.</p>
  
  <p>this works:
  Instr(columnA,'XX') IN (1,3,5,7,9,11,14,16)</p>
  
  <p>But is there a better way than to do this for every value I am searching for?
  Could I use COALESCE some how?</p>