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.
See Question&Answers more detail:os