title: remove text between square brackets
body: <p>I am trying to remove the text between the square brackets, however it only seems to remove the brackets.</p>
  
  <pre><code>SELECT Replace(Replace(aud_desc, '[', ''), ']', '') from _audit
  </code></pre>
  
  <p><code>aud_desc</code> is <code>This is [a] test</code> however with the above I have got it to show <code>This is a test</code>, I am not sure why its not removing the text in the brackets as well. </p>
  
  <p>Have I missed something?</p>