[thelist] Sorting with SQL

rudy rudy937 at rogers.com
Tue Sep 23 18:11:32 CDT 2003

> 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
> order.


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


More information about the thelist mailing list