>The speed improvements? I have seen speed improvements of 10X or more...
>
>So you see, the seek is a bit of a red herring here.. The real speed is in using the WHILE clause. Not the FOR clause. I bet 80% of the time a FOR clause is used, A WHILE clause with a SEEK could be used instead, dramatically improving performance...
>

I see... my mistake.. I thougt we were comparing finding a record with seek vs locate... You're right, I use the SEEK, SCAN REST WHILE all the time.

Let's not get into LOCATE vs GO TOP either... {G}

BOb