You're trying to compare apples and oranges. Since the field is of type
text, it will sort by text. Therefore, the result will be 1 then 10 then
1a and so forth. It is sorting based on ASCII. The only way to get it to
sort in proper numerical order is to make the field a numeric field. But
of cour
That list looks like an ordering that is custom to your application. The
latter sort created by the SQL seems more typical (correct?) to me.
I would return the table unsorted, and write the sorting routine in the
calling code instead.
-Original Message-
From: [EMAIL PROTECTED]
[mailto
