title: Using RTRIM in JOIN condition
body: <p>I want to put two tables which are containing Products together by their DESCRIPTIONs</p>
  
  <p><code>TABLE 1: [..fields..] [DESCRIPTION1] [..fields..]</code></p>
  
  <p><code>TABLE 2: [..fields..] [DESCRIPTION2] [..fields..]</code></p>
  
  <pre><code>SELECT [..fields..] FROM TABLE1,TABLE2 
      INNER JOIN TABLE1 
      ON TABLE1.DESCRIPTION1 = TABLE2.DESCRIPTION2
  </code></pre>
  
  <p>But in lots of cases, there are descriptions in both tables ending with an space, i also want to get them, thatswhy i tried it that way:</p>
  
  <pre><code>SELECT [..fields..] FROM TABLE1,TABLE2 
      INNER JOIN TABLE1 
      ON TABLE1.DESCRIPTION1 = TABLE2.DESCRIPTION2 
      OR RTRIM(TABLE1.DESCRIPTION1) = RTRIM(TABLE2.DESCRIPTION2)
  </code></pre>
  
  <p>Which produces no error, but does not bring more data.</p>
  
  <p>Is anybody able to help me?</p>
  
  <p>Every help is appreciated :) </p>
  
  <p>Thanks in Advance, Harry</p>