>I am having a problem sorting my table correctly. I would like to get all of my contents in field a in alpha order and all of my contents in fieldb in numeric order as the secondary sort.
>
>I have tried this put the field2 does not sort right.
>
>inde on field1 + alltr(str(field2)) to c:\temp\inde1
>
>It doesn't put the field2 in the right order. Field 2 has positives and negative numbers in it. Does anyone know another way to sort this?
>
>Thanks in advance.
Todd,
index on field1+padl(field2+aConstantHighValue,20,'0')
Cetin