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.