This is not a piece of cake as I thought.
Have to replace few characters with few other characters in the string.
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?No, but if you find yourself doing the same REPLACE in several places in your code, you can roll it into a function for ease of programming and clarity.|||Please ealborate a little...first read the sticky at the top of the forum...but my guess is you need to fix a table in one shot...
I would write a view, unload it, then reload the table...
Just a guess though
I hate DB2 OS/390
Wednesday, March 28, 2012
Replacements of substrings in strings
Labels:
cake,
characters,
database,
microsoft,
mysql,
nested,
oracle,
piece,
replacements,
server,
sql,
string,
strings,
substrings
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment