SQL Update Replace part of text from a string
14,122
Update Backup
set ImageURL =replace(ImageURL,'/s/','/I/')
Author by
Admin
Updated on June 23, 2022Comments
-
Admin almost 2 years
I'm using MS Access and I have a table called
Backup
and a column namedImageURL
. TheImageURL
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