>I have an application that needs a compound index built. The fields are all string fields, but the user would like the second field to be in descending order. Is there a good way to do this in VFP?
>
Something like
INDEX ON field1 + CHRTRAN(field2, ;
"0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz", ;
"zyxwvutsrqponmlkjihgfedcba`_^]\[ZYXWVUTSRQPONMLKJIHGFEDCBA@?>=<;:9876543210") TAG t1
--sb--