title: SQL Update Replace part of text from a string
body: <p>I'm using MS Access and I have a table called <code>Backup</code> and a column named <code>ImageURL</code>. The <code>ImageURL</code> column has data such as: <code>http://domain.com/s/1234.jpg</code>.</p>
  
  <p>I want to change the <code>/s/</code> in the URL intoto <code>/l/</code> by using an MS Access SQL Update and Replace.</p>
  
  <p>When I'm trying it at the moment, it's replacing the <em>entire field</em> to <code>/l/</code>.</p>
  
  <p>Thanks for your help!</p>
  
  <p>Rob</p>