I'm using MS Access and I have a table called Backup and a column named ImageURL. The ImageURL column has data such as: http://domain.com/s/1234.jpg.
I want to change the /s/ in the URL intoto /l/ by using an MS Access SQL Update and Replace.
When I'm trying it at the moment, it's replacing the entire field to /l/.
Thanks for your help!
Rob