"li yuqian" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > i tried your sql, but get a error: > --------- > SQL error: no such function: substring > --------
In SQLite, it's named substr. Check the documentation to make sure it expects the same parameters as substring in MySQL (with which I'm not familiar), adjust as necessary. http://sqlite.org/lang_expr.html I'm particularly suspicious of substring(v.value,1,0) - it appears to always produce an empty string. What is it supposed to do? Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
