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...
Best regards, Wolfgang