title: SQLite - replace part of a string
body: <p>Is it possible using <code>SQL</code> in an <code>SQLite</code> table to replace part of a string?</p>
  
  <p>For example, I have a table where one of the fields holds the path to a file.
  Is it possible to replace parts of the string so that, e.g.</p>
  
  <pre><code>c:\afolder\afilename.bmp
  </code></pre>
  
  <p>becomes</p>
  
  <pre><code>c:\anewfolder\afilename.bmp
  </code></pre>
  
  <p>?</p>