title: SQL CONCAT String + Column in WHERE clause
body: <p>I got a numeric value in Foo.A and it has its equivalent in Bar but with a string prefix ("Z"). I'm trying to <strong>append the "Z" to the Bar.A col value</strong>. I also tried with <code>CONCAT</code> but without any success. This following codes returns "Unknown column Z".</p>
  
  <pre><code>UPDATE Foo, Bar
  SET Foo.B = Bar.B
  WHERE Foo.A = Z + Bar.A
  </code></pre>
  
  <p>For example 14 (Foo.A) = Z14 (Bar.A).</p>