Hi List: May be of interest to add in the doc, that, when the second argument is negative, "the the first character of the substring is found by counting from the right rather than the left", but remember that the last actual character is -2, because -1 is just the ending NULL.
Of course it is rather obvious, but to me supposed some headache. HTH. A.J.Millan _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users