title: replace a column using regex in ms access 2010
body: <p>There's a table named sample including only one column, body (type: text) in ms access 2010:</p>
  
  <pre><code>&lt;name&gt;John&lt;/name&gt;&lt;age&gt;12&lt;/age&gt;
  </code></pre>
  
  <p>I'd like to delete every string inside the brackets. See this:</p>
  
  <pre><code>John12
  </code></pre>
  
  <p>I added Microsoft VBScript Regular Expression 5.5 library and create this module:</p>
  
  <pre><code>Function Replace_Regex(str1, patrn, replStr)
  Dim regEx
  Set regEx = New RegExp
  regEx.Pattern = patrn
  regEx.IgnoreCase = True
  
  Replace_Regex = regEx.Replace(str1, replStr)
  End Function
  </code></pre>
  
  <p>And then, I run this query:
      update sample
      set body = Replace_Regex(body, "&lt;[^>]+?", "")</p>
  
  <p>But the result is:</p>
  
  <pre><code> ame&gt;John&lt;/name&gt;&lt;age&gt;12&lt;/age&gt;
  </code></pre>
  
  <p>So, what's the problem?</p>