SQL Update Replace Part Of Text From A String

Question

I am using MS Access and I have a table called Backup and a column called ImageURL . The ImageURL column has data such as: http://domain.com/s/1234.jpg .

I want to change /s/ in the intoto /l/ url using MS Access SQL Update and Replace.

When I try at the moment, it replaces the entire field with /l/ .

Thanks for your help!

Rob

Answer 1

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