Replace Data in a table

  • Thread starter Thread starter Dimitris
  • Start date Start date
D

Dimitris

Hello in a table there is a field that is a text field but it has numbers in
it. I need to change all data that starts with 010 to 210. The field is not
a numeric field. How can I do it?
Thanks in advance.
Dimitris
 
Use an update query.

UPDATE YourTable
Set SomeField = "2" & Mid(SomeField,2)
WHERE SomeField Like "010*"
 
Back
Top