title: "Undefined function" when using a function in a join?
body: <p>I'm getting an irritating issue on a join and I was wondering if there is a way around it.</p>
  
  <pre><code>RIGHT JOIN TableB B ON B.Field1 = A.Field1 AND Str(B.Field2) = A.Field2
  </code></pre>
  
  <p>For some reason, putting Str() in the join throws an "Undefined function 'Str' in expression"</p>
  
  <p>Yet if I don't do this, I get a type mismatch.  Very frustrating.  Any workarounds short of changing the data type in my column?</p>