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: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: 11 September 2009 22:40 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Does SQLite have an Instr function? RB Smissaert <bartsmissa...@blueyonder.co.uk> 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 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