This may be a basic SQL question, but I can't find the answer in the SQL-related documents on the site, so...
I have a field in a table that is typed as text, though it is 99% of the time numerical. (It's used to track issue numbers of magazines, which for some esoteric publications may be alphanumeric.) I'd like to sort a query by this field, but when I do so "2" sorts after "10", as is the age-old comp-sci problem with treating numbers as strings. Is there a way, maybe with some variant of "SELECT field AS", to get SQLite to treat this data as numerical for the sake of sorting? Randy -- """"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""" Randy J. Ray Campbell, CA http://www.rjray.org [EMAIL PROTECTED] Silicon Valley Scale Modelers: http://www.svsm.org
