title: Oracle find values in varchar
body: <p>Is there any chance to find an exact value in a varchar using oracle sql?</p>
  
  <p>I need to find an exact value in a String (see output).</p>
  
  <p>This is my sql output:</p>
  
  <pre><code>Rights (varchar)
  -----
  #1  ( ID IN ( 1560 , 1760 , 1860 , 20200 , 3530, 16000 ) ) 
  #2  ( ID IN ( 1600 , 20000 , 100000 ) ) 
  </code></pre>
  
  <p>I want to filter for example String <code>1600</code> and <code>1660</code>.</p>
  
  <p>In this case only <code>#2</code> should be shown.</p>
  
  <p>I tried <code>and table1.rights like '%1600%'</code> which of course doesnt work because it shows me <code>#1</code> as well which is wrong.</p>
  
  <p>I also found this about using split which I cant integrate</p>
  
  <p><a href="http://lalitkumarb.com/2014/12/02/split-comma-delimited-string-into-rows-using-oracle-sql/" rel="nofollow">http://lalitkumarb.com/2014/12/02/split-comma-delimited-string-into-rows-using-oracle-sql/</a></p>
  
  <p>Any ideas?</p>