Many thanks! And my client would thank you, too, if only they new:-) (My test data set is paltry at best).


>Hi Nancy ----
>
>>Is LOCATE FOR going to be relatively efficient for a situation where SET KEY limits the records to, oh, a few dozen records at most? IOW, does LOCATE FOR use the SET KEY index? I have hardly ever issued a locate, since have been scarred by them in Clipper days. :-)
>
>I just tested this with a 60,000 record table. I set the index to lastname, did a SET KEY TO "SMITH" and then a LOCATE FOR lastname="SMITH"....it came up very fast.