title: Replace characters in Access
body: <p>I am trying to replace characters starting from a specific position in string but it seems to only replace and remove characters at the beginning let's say I am trying to replace this:</p>
  
  <pre><code>0000000000
  </code></pre>
  
  <p>with </p>
  
  <pre><code>00AAAAAA00
  </code></pre>
  
  <p>The first two and the last two characters should not be replaced. However when using this query</p>
  
  <pre><code>Update Table1
  set col1=replace(col1,'0','A',2,8)
  where Table1.col2='R';
  </code></pre>
  
  <p>I get this</p>
  
  <pre><code>AAAAAAAA0
  </code></pre>