[sqlite] Select WHERE IN List ordering

Hi, I have the following query: SELECT id FROM pointslocation WHERE id IN (1,7,3,4,5,2,6) What 's returned is 1,2,3,4,5,6,7. How do I retain the order in the IN list? jb ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Sort Alphanumeric, Numeric data in a VARCHAR

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