>Hi,
>I need to be able to create an index with 2 fields where the first column is ascending and the second column is descending. They are both character fields. This is how the data looks:
>
>Ts# Pr#
>------------ ----------
>98-10017-A 108155
>98-10016-A 106997
>98-10015-A 107070
>98-10013-A 105211
>98-10010-A 105210
>98-1001-E 118757
>98-1001 CB 114641
>98-1001 125183
>98-1001 121756
>98-1001 109035
>
>I am using the follwing index expression:
>UPPER(ts_number)+LTRIM(STR(pr_number,8,0)) DESCENDING
>
>However, I really need it to be ascending on the first column, descending on the second within this same index. Any ideas?
>
>I have no idea how to post in fixed width so I apologize for the formatting of the data above. TS# is actually 30 characters long.
>
>Thanks in advance.

UPPER(ts_number)+bintoc(-pr_number)