On 10 Sep 2012, at 5:36pm, Bart Smissaert <bart.smissa...@gmail.com> wrote:
> Yes, you are right there. > As rtrim incorporates an instr type of function I am not sure why there > is no plain instr function in SQLite. It would make things a bit simpler. Two ways to add appropriate functions to SQLite to do it. Either supply a 'find substring' function which returns the character number of where the substring is found, or supply a GLOB-type or regexp-type 'replace' function. Neither of them are trivial given that strings /may/ be 16-bit. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users