Hyperlinked files moving to new server

[annie52]

I have to move my database and external files to a new server. How can I update the path to these linked PDF files in my table? (e.g., J:\123\ABC\SomeFileName.pdf is moving to L:\456\DEF\NewBranchLocation\SomeFileName.pdf)

I expect to use an Update query but can't figure out how to replace just the beginning portion of the hyperlink address. Not all of the filenames are the same length (e.g., J:\123\ABC\SomeFileNameOrOther.pdf) so I can't parse using the Mid function.

 

[annie52]

I'm not sure why I was trying to make this harder than it had to be. A simple Find and Replace did the trick.