>>>Napoleon;
>>>
>>>As was stated, if you are using ADO you can use the Find method. To me Find is slow but simple and I prefer to create a new SQL statement to obtain the data I require. This may result in quicker response time if you are using large data sets.
>>>
>>>Tom
>>
>>The find method of ADO is optimizable by creating an index on the field you are searching.
>
>FYI, the Find method doesn't use any index. The Seek method does.

The Find method should also use an index, if the provider supports indexes. See the following article/s: http://msdn.microsoft.com/library/psdk/dasdk/mdad4mib.htm