Thanks Craig,

But what about if the descending index field type is 'C' or 'N'?

Regards
Amit


>>Craig,
>>
>> I am writing general function for that. I dont have specific fields but i can give example.
>>
>> I want to index the following fields
>>
>>1) Company C(05) Ascending
>> AccountCode C(05) Ascending
>> DueDate D Descending
>
>
>INDEX ON Company + AccountCode + STR({^2100-12-31}-DueDate)