database engine reporting string replace() as "no such function".
I enter into the ExecuteSQL window:
select replace(category,'Auto','NewAuto') from mytable;
The Errorse message from database engine is :
no such function: replace
I can run this same select statement from the sqlite3 command line interface and it works.
It could be the database engine has the bug, or maybe SDB needs updating with new db engine.