Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
computerforce
Starting Member
10 Posts |
 Posted - 2006-04-21 : 06:52:53
|
| This is not a piece of cake as I thought.Have to replace few characters with few other characters in the string. This should be the part of the running query on the fly.Now, I am using nested Replace:(Replace(Replace(MyString,'Ü','UE'),'Ö','OE')This example is simplified, number of replacements is more than eight of them.Is there any other, more elegant, way to do this in just one command? |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-04-21 : 08:14:22
|
| I do multi-level nested replaced frequently, so my only suggestion is that you stop worrying about it!Kristen |
 |
|
|
|
|
|
Replacements of substrings in strings