SQL Replace multiple different characters in string

Question

I need to replace multiple characters in a string. The result can't contain any '&' or any commas. I currently have: ``` REPLACE(T2.[ShipToCode],'&','and') ``` Which converts `&` to `and`, but how do you put multiple values in one line?

Accepted Answer

You just need to daisy-chain them:

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

SQL Replace multiple different characters in string

Solution

Problem