SQL Replace multiple different characters in string
<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>