thedevguy schrieb am 29.11.2010 um 15:43 (-0000):

> Does Firebird contain a natural sort order algorithm of some kind? We
> have an alphanumeric field that we would like to sort in the following
> order:
>
> 1
> 10
> 100
> 1010
> 20
> 25
> 123aef
> aef123

Maybe it's just me but I cannot see the rule you seem to be applying
to the data to sort it. It doesn't appear to be either numeric or
character-based.

--
Michael Ludwig