Am Montag, den 01.02.2010, 22:55 +0100 schrieb Jean-Christophe Deschamps: [...] > > Try this: > > SELECT * FROM mytable WHERE myfield glob '[0-9]*' >
thank you for opening my eyes - it seems that I never read http://www.sqlite.org/lang_expr.html#glob with total awareness. "The GLOB operator [...] uses the Unix file globbing syntax for its wildcards." But the reason might be that I usually don't use Linux for shell operations because in the office I've to use WinXP. Maybe someone could replenish the documentation with a few examples for the disadvantaged MS users? Oliver _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
