Fitter Man wrote: > I tried something for kicks and it worked. I flipped all the column > definitions from VARCHAR(255) to INTEGER and my query, above, works > properly. I did a little reading and found this described my problem: > http://www.sqlite.org/datatypes.html . > > > Q: Is their some inverse problem now that all the columns are defined as > INTEGER? Is there anything that might go wrong with a casual query of mostly > or all string values in a column that's declared INTEGER? > >
If you define the column as integer, you get a sorting order that is alphanumeric but which respects numeric sequencing: b a 300 30a 9 sorts as: 9 300 30a a b HTH John Elrick Fenestra Technologies _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
