Simon Davies wrote: > If your data is in an integer column then an order by on the data > column gives what you ask for: > SNIP > sqlite> select data from tst2 order by case cast( data as integer > )=data when 1 then cast( data as integer ) else data end; > 1 > 4 > 9 > 10 > 51 > a
Thanks very much for your assistance Simon. The first case may indeed work, the field is currently varchar but there is nothing preventing me from making it integer, and the second case gives me some insights I hadn't considered. Appreciate your time, John Elrick _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
