Hi all I'm very much a beginner with sqlite3 and and I'm completely stumped with using the replace function.
What I have is a field (TheOldField) with values like: HM1 HP4 HM3 HM2 and I need to replace all "P" with "+" and all "M" with "-", and put the result into a new field (TheNewField). All the documentation everywhere suggests I should use the replace function. So what I'm trying to do is (just for the P's at first): UPDATE TheTable set TheNewField = replace(TheOldField, "P", "+"); but doing this I get the error message "SQL error: no such function: replace" Which I dont understand. Can anybody tell me what I'm doing wrong or offer an alternative solution? Thanks, Ben -- View this message in context: http://www.nabble.com/SQL-error%3A-no-such-function%3A-replace-tp22194822p22194822.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
