Thanks,

I will try this.

Regards
Amit

>>Thanks Craig,
>>
>> But what about if the descending index field type is 'C' or 'N'?
>>
>>Regards
>>Amit
>>
>>
>
>Numeric is easy, just subtract from a bigger number and convert to string:
>
>STR(999999999 - MyField)
>
>Character is more complicated. You could write a UDF that converts each letter to it's ASCII value.