For those who don't recall, EBCDIC is the ancient char system that orders like this in a natural ascending string sort:
1) lower alpha
2) upper alpha
3) digits
Quite the opposite of ASCII. Anyone think of a way to simulate this sort with a vfp index, on a field with mixed alphanumeric as below? These strings are varying in length, and I really want a structural index for this, not SQL or looping techniques involving code. I may be barking up the "impossible tree" here, but sometimes a fresh perspective can see some idea someone else has missed...
For example, given this sequence:
12G5A77
123C6H
12AB5
123C6h
I want to get:
12AB5
12G5A77
123C6h
123C6H
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.