>Greetings!
>
>I need to set up an index to sort records using a mix of ascending and descending orders, using character fields.
>
>I recall this could be done using the SYS(15) function ("included for backward compatibility"). I've done it before, but now do not remember how! Apparently, the list of fields in the sort order would include something like "SYS(15, "ZYXW...", field)". This would cause the field to be sorted in descending order by substituting each character--a "Z" for an "A", "Y" for "B", and so forth.
>
>However, it does not work. Does anyone else know how to do this?
>
>Thanks!
>
>Michael Reynolds
Michael,
sys(15) was for char. translation table but at the end what would you get ? You just try to have a descending index ?
AAAAAA
BBBBBB
CCCCCC
sorted as :
CCCCCC
BBBBBB
AAAAAA ? If what you want is this simple then index has a keyword descending. OTOH you can use any index descending by using "descending" keyword of "set order".
Cetin