title: Replace string in Apache Derby
body: <p>Does Apache Derby have a way of replacing a string with another string?</p>
  
  <p>I'm looking for something like:</p>
  
  <pre><code>select
      replace('bruce bogtrotter', 'bruce', 'john')
  from SYSIBM.SYSDUMMY1
  </code></pre>