Hi, I'm having trouble sorting the following data:
point_number - VARCHAR(10) ------------ 11.01 11.23 77.01 55.09 A06 1010.01 1010.09 A03 If I do: SELECT point_number FROM mytable ORDER BY point_number; I get the following: 1010.01 1010.09 11.01 11.23 55.09 77.01 A03 A06 When I do the following: SELECT point_number FROM mytable ORDER BY point_number+0; I get the following: A03 A06 11.01 11.23 55.09 77.01 1010.01 1010.09 I would like to have them ordered in the following sequence: 11.01 11.23 55.09 77.01 1010.01 1010.09 A03 A06 How can I get the A03, A06 at the end of the list? TIA gary _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
