user1531184 user1531184 - 5 months ago 15
SQL Question

SQL Update Replace part of text from a string

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
Update Backup
set ImageURL =replace(ImageURL,'/s/','/I/')