CONCAT equivalent in MS Access

ms-access, ms-access-2010, sql

Solution

UPDATE myTable
SET [My Column] = "Prefix " & [My Column] 
WHERE [Different Column]='someValue';

As far as I am aware there is no CONCAT

Problem

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 Basically I need this translated to a command that will work in access: ``` UPDATE myTable SET [My Column] = CONCAT ("Prefix ", [My Column]) WHERE [Different Column]='someValue'; ``` I've searched up and down and can't seem to find a simple translation.

Original source