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

Accepted Answer

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

SQL Update Replace part of text from a string

Solution

Problem