>What is the best way to create a compound index with integer fields?
>
>field1 is integer.
>field2 is integer.
>
>When I create an index like INDEX ON field1 + field2 TAG tagname1, foxpro seems to get "confused".
>
>Must I use the STR() function around field1 and field2?

Hi Andy,

Look at the BINTOC() function. It converts integers into strings that I think might solve your problem.