title: Comparing column string values in oracle
body: <p>I have table in which I need to compare the values from two columns.</p>
  
  <pre><code>Col1      Col2        Col3
  ------------------------------------
  1         sssXYZ2121  XYZ   
  </code></pre>
  
  <p>Now a match may not be a perfect word to word match. </p>
  
  <p>E.g. of a match</p>
  
  <pre><code>Col2    Col3
  -----   --------------------
  XYZ     XYZ                  (word to word match)
  XYZ     xyz                  (can be case insensitive)
  XYZ     gxyzf                (need to search within a string )
  XYZ     xyzjjjjjjjjj         (need to search within a string )
  XYZ     gggggXYZ             (need to search within a string )
  XYZ     Xavier Yellow Zebra  (Match the full form of the abbreviation)
  </code></pre>
  
  <p>Now I need to find all the rows in which the value in <code>Col3</code> do not match <code>Col2</code>.
  I am using Oracle 10g.</p>