On 11 Sep 2009, at 10:30pm, 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.
<http://www.sqlite.org/lang_corefunc.html>
No, but it does have many of the functions you'd use that function
for. For instance you can do a replace without needing instr. You
also have LIKE and GLOB, from
http://www.sqlite.org/lang_expr.html
Simon.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
