title: CONCAT equivalent in MS Access
body: <p>I'm doing some work in MS Access and I need to append a prefix to a bunch of fields, I know SQL but it doesn't quite seem to work the same in Access</p>
  
  <p>Basically I need this translated to a command that will work in access:</p>
  
  <pre><code>UPDATE myTable
  SET [My Column] = CONCAT ("Prefix ", [My Column]) 
  WHERE [Different Column]='someValue';
  </code></pre>
  
  <p>I've searched up and down and can't seem to find a simple translation.</p>