Hello, I'm using sqlite3 and have a list of numbers I'd like returned sorted in increasing order: 1 1.1 1.10 1.11 1.9 10 11 9 12
However, if their column is defined as numeric, the 1.10 gets converted to 1.1 (which is not what I want) and the result (using ORDER BY) is: 1 1.1 1.1 1.11 1.9 9 10 11 12 I tried defining the column as a text and while the 1.10 is preserved, but I get dictionary-style results: 1 1.1 1.10 1.11 1.9 10 11 12 9 Any quick and easy solutions. Thanks, SD The information transmitted is intended only for the person(s)or entity to which it is addressed and may contain confidential and/or legally privileged material. Delivery of this message to any person other than the intended recipient(s) is not intended in any way to waive privilege or confidentiality. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by entities other than the intended recipient is prohibited. If you receive this in error, please contact the sender and delete the material from any computer. For Translation: http://www.baxter.com/email_disclaimer
