title: finding and replacing text in a access table column
body: <p>I am trying to find and replace 'some text' inside a access table column with new data as show below.</p>
  
  <p>this is some text inside column data</p>
  
  <pre><code>Update table set column = Replace(column, 'some text', 'new data')
  </code></pre>
  
  <p>this does not work with access databases, is there another way of performing the same action?</p>