Dumb me. I added the index via my form that maintains indexes and I guess I did not actually tell it to reindex. I then noticed a few things I wanted to change on that form. Made the changes and tested and just didn't realize I'd never reindexed. Then I went straight past the simple fact that the index did not exist and was looking for something more complex. It often is something more complex, so sometimes I forget to check the simple stuff. Thanks for your replies (and macro substitution does not make a difference as we both believed - I didn't make it clear but I was doubtful that was the issue).

>AFAIK it should not make a difference, but you may test direct query just in case.
>
>
>>I didn't believe there was anything else in the statement that was pertinent to the question that I didn't already post, but then I remembered this does use macro substitution. I'll have to test to see if that makes a difference.
>>
>>

>>WhereClause = "right(PrSSNum,4) = '1234'"
>>select PrEmpl, PrFirst, PrLast, PrSSNum, PrDept, PrDOH;
>>   from PrEmpl;
>>   where &WhereClause;
>>   into cursor SearchTempCursor readwrite
>>

>>
>>I had indicated my version (VFP 9 SP 1), but I did a preview of the post. If you do that and then submit it, it loses the settings for version, database, etc. Kind of an irritating problem that I mentioned to Michel, but one that he said would be fixed when they moved completely to ASPX for the site and would not fix in the current version.
>>
>>