Hi Jay, list. Many thanks for your comments. In many cases, exporting the table as a textfile and using sed to search and replace will be a very good solution. Thanks! But Jay: how can I implement a function "MyFunction" like in your example? Could you give me a hint? That would be really great!
> UPDATE myTable SET MyField = MyFunction( MyField ); Best regards, Wolfgang Am Dienstag 08 August 2006 pH:05:16 nachmittags/abends schrieb Jay Sprenkle: > On 8/8/06, Olaf Beckman Lapré <[EMAIL PROTECTED]> wrote: > > How would this compare to the performance of simply (progammatically) > > doing an UPDATE and changing the values in a callback hook. If this is > > impossbile than even a SELECT with a callback where one does an UPDATE > > for each returned row would be possible. > > If this was a task that needed to be done many times I would create a > program to do it. If it is a one time fix the manual solution suggested > would be quicker. > Sed/ed/awk/vi/elm work very well if you know how to use them. > > You might also try to write a user defined function that edits your > text as desired. > Then you can simply use one update statement: > > UPDATE myTable SET MyField = MyFunction( MyField );
