Hi Doug,

>Sometimes FoxPro creates a temporary index after attempting to use what's already there but I don't know for sure.

Yes, the SQL engine does this especially for JOIN conditions. That's one reason why SET COLLATE is causing so much trouble. *g*

Christof