Re: [sqlite] SQL error: no such function: replace

omely fast replies by the way - really appreciated. Ben John Machin wrote: > > On 25/02/2009 1:13 PM, BenJones12345 wrote: >> Hi all >> >> I'm very much a beginner with sqlite3 and and I'm completely stumped with >> using the replace function. >&

[sqlite] SQL error: no such function: replace

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). A