Access update query question

[Ktulu]

If i have records in a table with the following values:

table_name = Asset

asset# location
-------- -----------
10000 BC100
10001 BC101
10002 BC102
10003 BC102A
10004 AC101
10005 DCD101

is there any way to write an update query to change the "BC" in the location field to "BCD" on all locations that start with the "BC"

Any help would be appreciated.

 

[Ktulu]

Figured it out myself.

update Asset set location = "BCD"& right (location, LEN(location)-2)
where location like "BC*"