SQLite Forum

Alternative for nesting REPLACE()?
Unfortunately you are barking up the wrong tree......
This was never about UPDATEs - the usage of REPLACE is intended for cleaning up output and/or fixing issues with UTF8 and ORDER.
And nesting REPLACE does not work - by the time I had reached the required level of nesting I was rewarded with a stack overflow.