SQL Update Replace part of text from a string

Question

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

Answer 1

Update Backup
set ImageURL =replace(ImageURL,'/s/','/I/')