SQL Replace multiple different characters in string

sql replace sql-server-2016
coblenski picture coblenski · Aug 30, 2016 · Viewed 71.8k times · Source

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')

But how do you put multiple values in?

Many thanks!

Answer

Siyual picture Siyual · Aug 30, 2016

You just need to daisy-chain them:

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

Related questions

UPDATE and REPLACE part of a string

I've got a table with two columns, ID and Value. I want to change a part of some strings in the second column. Example of Table: ID Value --------------------------------- 1 c:\temp\123\abc\111 2 c:\temp\123\abc\222 3 c:\temp\123\abc\333 4 c:\temp\123\…

Read More
How to replace specific values in a oracle database column?

I am looking to replace values in a particular column. For example the following column values column name ---------- Test1 Test2 Test3 Test12 should be (replacing est1 with rest1) column name ---------- Trest1 Test2 Test3 Trest12

Read More
MySQL search and replace some text in a field

What MySQL query will do a text search and replace in one particular field in a table? I.e. search for foo and replace with bar so a record with a field with the value hello foo becomes hello bar.

Read More