Replace multiple values from string in numbers sql

Question

Hey Friends I want to replace 1 to 'asd' and 10 to 'asdddd' in a string like 1and2and10 but it replace it to 'asd'and2and'asd'0 in sql server please help.

Thank you

share whatever you have tried yet. some query or anything other. — maulik kansara
– maulik kansara, Commented Aug 2, 2018 at 6:22
Please add some sample data and also anything you have tried. — Tim Biegeleisen
– Tim Biegeleisen, Commented Aug 2, 2018 at 6:25

Michał Turczyn · Accepted Answer · 2018-08-02 06:23:49Z

1

Try:

SELECT REPLACE(REPLACE('1and2and10' , '10', 'asdddd'), '1', 'asd')

or with table:

SELECT REPLACE(REPLACE(myColumn , '10', 'asdddd'), '1', 'asd') FROM myTable

answered Aug 2, 2018 at 6:23

Michał Turczyn

41.2k18 gold badges58 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Soul_Hunter Over a year ago

I am not sure if this will be the string every time and number can go up to 100 in this case so I can not take risk of hard codes

Michał Turczyn Over a year ago

@Soul_Hunter Then update the question and include all cases. What you saying now wasn't mentioned in question.

Soul_Hunter Over a year ago

I am saying that there can be a case when (1and2and3and4)or(3and29and1)

Collectives™ on Stack Overflow

Replace multiple values from string in numbers sql

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related