Access VBA Find and replace within a table and field

Hi

How do I do a find and replace within a table or a field
within that table.

eg replace "D" with "C" within tblTest
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
rockiroadsConnect With a Mentor Commented:
All occurrences of the character?

e.g. run this query

update mytable
set myfield = replace(myfield,"D","C")


obviously do backups of your db/table before modifying data
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Great thanks.

Yes all occurrences.

Thanks again for such a quick and concise answer

0
 
rockiroadsCommented:
no worries :)
0
All Courses

From novice to tech pro — start learning today.