Subject Re: [firebird-support] Natural Sort Order
Author Paul Vinkenoog
Philippe wrote:

> > No, we don't have that ;-)
> hum, I think we have

Yes, but that's not what the OP wants, based on his example. What we call NUMERIC-SORT is often called natural sort. I gave an example of this ordering in my reply. What the OP wants differs from NUMERIC-SORT (natural sort) in two ways:

1) He wants to sort numerals lexicographically, not by their numerical value.
2) He wants all pure numerals first, followed by the values that also contain alpha characters.

At least, that's how his example is ordered.

Paul Vinkenoog