John Cobby John Cobby - 11 months ago 79
SQL Question

SQL Replace multiple different characters in string

I need to replace multiple characters in a string. The result can't contain any '&' or any commas.

I currently have:


But how do you put multiple values in?

Many thanks!

Answer Source

You just need to daisy-chain them:

REPLACE(REPLACE(T2.[ShipToCode], '&', 'and'), ',', '')