Hi Peter, thank you very much for your reply. But is there no command within sqlite to do this? In my case, only substrings of the cells of one column need to be changed!
Best regards, Wolfgang Am Montag 07 August 2006 pH:19:16 nachmittags/abends schrieb Peter Cunderlik: > On 8/7/06, wqual <[EMAIL PROTECTED]> wrote: > > Hi list, > > I have sqlite 3.2.1 installed on my computer. Now, I need to replace some > > substrings in my sqlite-table (for example, replace 'strasse' with 'str.' > > , german 'รค' with 'ae' etc.). Can I search for the substrings and replace > > them by another one? I do not know, what would be the right syntax for > > this purpose and I would be really grateful for some hints... > > The most flexible replace would be to use the sqlite3 command line > utility to .dump your database or a table and replace the strings in > the dump directly. The dump follows the sql syntax, so you could > import the modified dump into your existing DB. > > Search for .dump on http://www.sqlite.org/sqlite.html . > > Peter
