I'm using MS Access and I have a table called
and a column named
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
Thanks for your help!