[thelist] SQL Order By Clause

[Colin Mitchell]

>
> Because, not all of the ID's are numeric .. some start with a unique
Letter,
> and some have letters added to the end of numbers, to indicate the same
> number for more than one product ID internally.  I'll have to check with
the
> client to see what is more important for their use.
>

I wonder - could you just pad the numeric values with zeroes?  Instead of
having '1' and '2', have '0001' and '0002'.  If you could do that, they'd
sort fine.

Colin