August 12, 2013 at 7:41 am
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:
"http://www......./forms/files/dlr-tlk-apr-2001.pdf"
I assume I need to use Replace. What would be the best way of doing this?
August 12, 2013 at 7:55 am
Without more information, you could test this.
UPDATE MyTable SET
file_path = REPLACE( file_path, '/Downloads/', '/forms/')
August 12, 2013 at 8:52 am
Thanks! That's actually what I was going to try but I thought I'd have to end up using it in conjunction with InString or FindSting or something similar.....
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy