[thelist] Sorting with SQL

[rudy]

> However when I sort by ascending order I get
>
>   ABC 10-3
>   ABC 1-2
>   ABC 3-6
>   ABC 4-5
>
> Is there a trick I can do to sort these (about 30) records in the
"correct"
> order.

yes

the trick is, pull out the numeric portion as a substring, convert it to
a numeric expression, and sort on that

if it's as simple as the examples you have just given -- namely, that the
numeric follows the first space, and is in turn followed by a dash -- then
it should be fairly strightforward

it would help to know which database you're using, because they all
have different string functions for finding a character and converting
a substring to a numeric

rudy