user1531184 user1531184 - 1 year ago 155
SQL Question

SQL Update Replace part of text from a string

I'm using MS Access and I have a table called

and a column named
. The
column has data such as:

I want to change the
in the URL intoto
by using an MS Access SQL Update and Replace.

When I'm trying it at the moment, it's replacing the entire field to

Thanks for your help!


Answer Source
Update Backup
set ImageURL =replace(ImageURL,'/s/','/I/')
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download