Best way to replace multiple strings in huge string

Question

Is there any other way to replace multiple strings in sql server 2008r2? which is also fast?

My query is below.

Select REPLACE(REPLACE(EmailText,'#{Name}#',UV.Name),'#{organisation}#',CV.Organisation)

I am written it with example also

Select REPLACE(REPLACE('Hi #{Name}# from #{organisation}#','#{Name}#','Jhon'),'#{organisation}#','Cocacola')

Other than using a clr function, sql server does not support regular expressions. Replace is probably the best way to do it. — Zohar Peled
– Zohar Peled, Commented Aug 17, 2017 at 6:42

Caius Jard · Accepted Answer · 2017-08-17 06:47:45Z

2

There are all sorts of ways:

But 'best' as in 'fastest' is probably going to be using REPLACE Repeatedly, as all the attempts in these links have some limitation..

answered Aug 17, 2017 at 6:47

Caius Jard

75k6 gold badges61 silver badges95 bronze badges

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

2 Comments

user2972061 Over a year ago

are you sure Replace is fast? I means if i will replace 5 to 6 strings, it wouldn't slow down the select statement?

Caius Jard Over a year ago

Depends what you mean by fast. Sqlserver can replace your strings faster than I can replace strings with a pencil and paper?! Of course any additional processing of data will reduce the rate at which results can be produced, but your question doesn't really make sense because you're asking for absolute when this operation is relative. If you have a million replacements to make, you have to make them somehow, and it's going to take some time. So go make them with replace, and if it's too slow, try something else from these links. I think you'll come back to using replace in the end though

Collectives™ on Stack Overflow

Best way to replace multiple strings in huge string

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related