Yes, but doesn't rtrim do an instr function with the same problems as you mention?
RBS On 9/10/12, Simon Slavin <slav...@bigfraud.org> wrote: > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
