Erico Leite <erico.barrien...@gmail.com> wrote: > Can I create a custom function to use in clause where? > > Ex. > select * from tbl where tbl.x myfunction '031';
No. You'll have to settle for myfunction(tbl.x, '031') > this function will go return all register with start '0' or '03' or '031'. This sentense doesn't make any sense to me, sorry. What's a "register" in this context? Anything that starts with '03' or '031' also starts with '0'. It seems that your condition is equivalent to " register (whatever that is) that starts with '0' ". -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
