OK, thanks, saves me looking further. I can add this function via the VB wrapper (Olaf Schmidt's dhRichClient3), but thought it might be faster if there was a pure SQLite implementation.
RBS -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Igor Tandetnik Sent: 11 September 2009 22:40 To: [email protected] Subject: Re: [sqlite] Does SQLite have an Instr function? RB Smissaert <[email protected]> wrote: > Does SQLite have a string function that produces the first position > of a string within another string? > For example select Instr('abcd', 'c') would produce 3 Unfortunately, no. Of course, SQLite does provide a way for you to add your own custom functions. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
