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
>>