title: Best way to compare VARCHAR2 with CHAR
body: <p>I'm searching for the best (and fastest) way to compare <code>VARCHAR2(50 BYTE)</code> with <code>CHAR(12 BYTE)</code>.</p>
  
  <p>There are two databases, first contains a table1 with CHAR column (underline means space characters to fill CHAR length)</p>
  
  <pre><code>ID  VALUE
  1   123-45___
  2   123-456__
  3   123-457__
  </code></pre>
  
  <p>second database (table2) contains VARCHAR2 without white space.</p>
  
  <pre><code>ID  VALUE
  4   123-45
  5   123-456
  6   123-457
  </code></pre>
  
  <p>So, I want something like this</p>
  
  <pre><code>SELECT table1.ID FROM table1 WHERE table1.VALUE = '123-45'
  </code></pre>