>If i'm only going to search for 1-2 records which of the following two methods is best (fastest)?


Marten:

In my code in general, I have settled on the SEEK() funtion as described by Bruce Campbell.

It's just as fast as the SEEK command and you can write it in one line. Also you don't need to select the table (an advantage over LOCATE) or set an index (an advantage over SEEK command).

Locate takes about 3 times longer. Not a big deal on one record, admittedly.

Peter Robinson