Replace Data in a table

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
 
J

John Spencer

Use an update query.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need to update a querie 4
Updating a very large database 1
Changing numbers 2
I need a message to pop up 4
Need to get a field to repeat in a table or query 5
Changing a field from text to date 7
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
Delete comma from the end of a field 6

Top