Subject Re: {Spam?} [firebird-support] Replacing substrings...
Author Sergio H. Gonzalez
>Peace o' cake:
>update changeme set field01 = replace(field01, 'Fpdd', '<newvalue>')

...and if the table has a lot of records, probably adding

where position ('Fpdd' in field01)> 0

would help... or it's the same, regarding performance?

-s



[Non-text portions of this message have been removed]