>To to get columns that begin with a number range or any number, I >would use >in SQL server: > >SELECT * FROM mytable WHERE myfield LIKE '[0-9]%' > >This obviously doesn't work in sqlite and I have been searching for an >equivalence.
Try this: SELECT * FROM mytable WHERE myfield glob '[0-9]*' _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users