title: Find and Replace All Special Character in SQL
body: <p>I want to copy all row in new column with replacing all special character with -. my code is below.</p>
  
  <p><strong>My table design</strong></p>
  
  <p><img src="https://i.stack.imgur.com/ZTtYB.png" alt="enter image description here">   </p>
  
  <pre><code> select * from mycode
      UPDATE mycode
      SET newName = Replace(myname, '%[^0-9a-zA-Z]%', '-')
  </code></pre>
  
  <p>It's getting copy with my code but the special character are not replaced</p>
  
  <p><strong>Result</strong>
  <img src="https://i.stack.imgur.com/sYSbU.png" alt="enter image description here"></p>