update message set data = replace (data, 'wmost','westernmost');
April 4, 2011 at 5:04 PM
thanks a lot i could do it with this, but the only problem is if i want to change "nmost" to "northernmost" this query also changes "southernmost" to "southernothernmost". if you notice then "nmost" is common in other strings also. is there a way to avoid this problem. Can you send similar query using regexp_replace expression so that it only identifies "nmost" and not anyone of these: southernmost, easternmost, northernmost, westernmost.
Really appreciate your help.
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.