title: SQL Replace multiple different characters in string
body: <p>I need to replace multiple characters in a string. The result can't contain any '&amp;' or any commas.</p>
  
  <p>I currently have: </p>
  
  <pre><code>REPLACE(T2.[ShipToCode],'&amp;','and')
  </code></pre>
  
  <p>But how do you put multiple values in?</p>
  
  <p>Many thanks!</p>