I've got a database of music and I added a new hard drive with more space. I simply need to update my DB to show this new path. It went from C:\Temp\Music\'random artists' to F:\Temp\Music\'random artists'
The issue is the 'random artists' is different for each song, and I can't make the set,replace,where,like to work.