Update query to find and replace with wildcards

[Bdowns]

CAT01 to CA01
CAT02 to CA02


CAT03 to CA03
CAT04 to CA04
CAT05 to CA05
...

How can I make all these updates in one shot? Thanks!

[orange]

Let's assume CAT01---CAT05 are values of field ZZZCode

(untested but I think it should work)

Update yourTableName
Set ZZZcode = Replace(ZZZcode,"T","")
WHERE ZZZCode in ("CAT01","CAT02","CAT03","CAT04","CAT05")

[ssanfu]

Not sure what you are asking. I seems you know to use an update query.
What have you tried?

If you do not want to edit the query, you could use VBA to execute the queries.

It just occurred to me (since you used "..."), there might be more than 5 changes.

If so, the VBA method might be better.
Create a table with two fields: "ChangeFrom" and "ChangeTo"
Using VBA, open a recordset, looping through it getting the from an to names. Execute the query.


Edit: Try Orange's solution first..... I keep forgetting about the replace function.