>When using two numeric values for a compound index it is typically better to separate the numbers with a delimiter, ie.
>
> ALLT(STR(field1)) + "-" + ALLT(STR(field2))
>
>Otherwise, your seeks will rarely get you the result you want. Note that the ALLTRIM() is used to reduce the size of the CDX file.
>
>-David
David:
A delimiter is absolutely necessary if you use allt() in your index expression because
allt(str(1)) + allt(str(23)) is exact than allt(str(12)) + allt(str(3))
But if you dont use allt() is not necesary at all. I use str(field1) + str(field2) in several tables and all my seeks works fine always.
Carlos.
Saludos,
A.G.P.
---------