Hi Steve,
Before create this index (used BINTOC()) you mus set COLLATE to MACHINE.
And before SEEK(), SELECT SQL, etc. you must set COLLATE to MACHINE too, and after set original COLLATE.
MartinJ
>I think I am on the right trail. We have a user that is having problems with some indexes. The indexes are created for Fox standalone tables right after the table is made. If the indexes are created on the users computer they do not find anything when you seek. If the indexes are created on other machines the the index works.
>
>The index is on BINTOC(CUS_PK)+BINTOC(CUS_CPK) Where CUS_PK and CUS_CPK are integers.
>
>Any help or suggestions would be appreciated.