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,.
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,.
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"));