How to change words in a column in a table

[hendrikbez]

I have a table with more than 6000 records, in one of the columns I have this info "5421MAG0001 - 5421MMAG6010" but now see that more than 300 of them has 5883MAG01-00000 in them I want to know how can I change this just to 5421 in all of them,.

[alansidman]

You could create an update query to change the value. Assuming your column (field name) is "Desc" and your table name is "Tbl1". Your SQL statement would look like this:

UPDATE Tbl1 SET Tbl1.[Desc] = "5421"
WHERE (((Tbl1.Desc)="5883MAG01-00000"));