Jean-Christophe Deschamps wrote: >> Yours returns 1 or 0. Mine returns length if found, otherwise 0. > > That's true but the subject title led me to believe that the OP > intended to have a 0 vs. nonzero return for not-exists vs exists condition.
Perhaps. Nevertheless, the answer to your specific question, namely "isn't the following exactly the same?", is no. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users