I have a field in a table which has hard coded paths for files. Like "http://www..../downloads/files/dlr-tlk-apr-2001.pdf"
I need to update all references to "downloads' and change it to "forms" so all of the paths would look like:
I assume I need to use Replace. What would be the best way of doing this?