>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.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer