title: isql "select ... where 'a part of a column value' = 'a part of a column value'
body: <p>I have 2 csv files. In one file I have a phone number with prices and in the second file I have a phone number with the name of its owner.</p>
  
  <p><strong>First file: file1.csv</strong></p>
  
  <blockquote>
    <p>491732234332;30,99<br>
    491723427343;12,59<br>
    491732097232;33,31  </p>
  </blockquote>
  
  <p><strong>Second file: file2.csv</strong></p>
  
  <blockquote>
    <p>01732/234332;Ben Jefferson<br>
    01723/427343;Jon Doe<br>
    01732/097232;Benjamin Franklin  </p>
  </blockquote>
  
  <p>My problem is, that the phone number columns are formatted differently and I can not find a way to compare them.</p>
  
  <p><strong>Desired output is:</strong></p>
  
  <blockquote>
    <p>01732/234332;30,99;Ben Jefferson<br>
    01723/427343;12,59;Jon Doe<br>
    01732/097232;33,31;Benjamin Franklin  </p>
  </blockquote>
  
  <p>My sql statement is</p>
  
  <pre><code>create temp table FILETB1
        (phonenr    char(30),
         price      char(30)
        );
  
  create temp table FILETB2
        (phonenr char(40),
         owner char(60)   
        );
  
         load from "file1.csv"
         insert into FILETB1;
  
         load from "file2.csv"
         insert into FILETB2;
  
         unload to "output.csv"
  
         select FILETB1.phonenr, FILETB1.price, FILETB2.owner
         from FILETB1, FILETB2
         where FILETB1.phonenr = FILETB2.phonenr
  </code></pre>
  
  <p>How do I have to modify my where clause to be able to compare both columns?</p>
  
  <p>We are working on linux with  <strong>IBM INFORMIX-SQL Version 7.50.UC5</strong> which makes finding a working solution not easier since many functions are not supported...</p>
  
  <p>Any help is highly appreciated!</p>