Thanks Philip I will give it a try.

Becky

>Hi Randy,
>
>Yes, you are correct. Sorry :)
>
>>You don't want to use ALLTRIM there, just STR. Using ALLTRIM will create different length keys for different records, and the ordering will not be correct.
>>
>>>For example, if first and third is characterm but second is a numeric, you could use:
>>>
>>>INDEX ON first+ALLTRIM(STR(second))+third TAG IndexName
>>>