Whoops! Not quite! How about:

index on UPPER(ts_number) + transform(99999999 - pr_number,'@L 99999999')

>Hi Randy,
>
>How about:
>
>UPPER(ts_number)+LTRIM(STR(99999999 - pr_number,8,0))
>
>>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:
>>