Replace field values

[ponneri]

Hi All.

I need to replace some values in a field called codes.

The field has a few hundred records with codes as follows

ES202EM202
ES13457EM13457
ES119EM119
ES20EM20
....

Basically, it was imported from excel, so the column has ES and EM codes with same suffix no. but varying widths. (text field)

I just need to remove the leading ES20 and retain the EM20 in the field and so on for all records where the value is in ES...EM... format.

How can I use the UPDATE command or is there a REPLACE command in Access 2007 ?

Please help.

 

[Minty]

Replace is available - syntax here https://www.techonthenet.com/access/functions/string/replace.php