Hi, Some time ago when there was no "instr" functions, I looked at Mysql help pages and implemented a user function "locate" as the one that allows searching starting a particular position in the string. With two parameters form it was just identical to "instr" only the order of parameters was reversed. As I see, the latest sqlite has only "instr".
It's not a big deal, but I noticed that "locate" with three parameters becomes convenient for CTE recursive queries since it allows search sequentially in the string. For example, a little bulky at last, but I managed to do "comma-list to dataset" query I suppose implementing "locate" and doing "instr" as a call to "locate" would cost the developers probably no more than a hundred of bytes for the final binary Thanks Max _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
