Subject Re: {Spam?} [firebird-support] Replacing substrings...
Author Paul Vinkenoog
munster7705 wrote:

> Ok, I've been trying to find something, on-and-off for two days, and can't. Here is what I have. Say I have a table called "changeme", with one varchar(30) field called "field01". I want to replace all occurances of the substring "Fpdd", in field01, but it doesn't appear in the same location in all records. How do I do it? Here is some sample data (none of it is real data).

Peace o' cake:

update changeme set field01 = replace(field01, 'Fpdd', '<newvalue>')

Next time, spend some minutes in the doc section rather than struggling for days ;-)

Paul Vinkenoog