John Cobby John Cobby - 7 months ago 59
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!


You just need to daisy-chain them:

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