Hello *

Is there a way to sort string data (varchar) in Firebird by a "natural"
or "logical" sort order, just like using the Windows API function
StrCmpLogicalW [1] ?

Sort result of text with numbers should be:

Item1
Item2
Item3
Item10
Item11
Item20
Item30

That is, sorting should treat the digits as numbers rather than text.

[1]

> http://msdn.microsoft.com/en-us/library/bb759947.aspx

TIA
Achim