This extension (extension-functions.c) has Charindex, which is basically the same as the VB instr.
http://www.sqlite.org/contrib I had to compile the C source code to make the sqlite extension: I assume you are on Windows because you use VB. I had to install the mingw compiler, small and easy to do. copy sqlite3.h to the same folder gcc -fPIC -lm -shared extension-functions.c -o libsqlitefunctions.dll fireup sqlite select load_extension('libsqlitefunctions.dll') there are other string and math functions as well. good to go! Keith RB Smissaert 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 > Looked in the documentation and the forum, but couldn't see it. > > RBS > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/Does-SQLite-have-an-Instr-function--tp25408688p25710160.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
