>Sergey, set century = on, I used the default for set date. I also had the same data on the local as was on the network?? Have used this index for a year or more, but recently moved to vfp9 from 8. Why the blowup now??
>The only change is the addition of the complex sql to the project.

VFP9 performs additionl checks for index key truncations compare to VFP8 in case where it could cause incorrect results.