title: TSQL - Remove special characters from a result
body: <p>I have a select compares data between tables and as of result, returns document numbers as for example like that:</p>
  
  <pre><code>date           docnumber          magnumber          desc
  Monday     DOC/X500/31321321    MAG/21321/X500   [RXC/X500/02132131][]
  </code></pre>
  
  <p>I would want to remove the special characters [][] from a result of a column 'desc'. Tried result/trim but It didn't give me a result I wanted.</p>