Seek cannot be beat for data retrieval based upon a single index expression. If you need to retrieve data based upon multiple optimized expressions the use either locate or SQL-Select.

ie. Locate for state='MI' and city='TRAVERSE' or
Selecte * from MyTable where state='MI' and city='TRAVERSE'

Glenn


>Moises,
>
>As Alex has said Locate can be as effective as Seek, however, you need to be very careful and ensure that your statement is Rushmore optimised or you will have a performance hit.
>
>Locate is powerful in that it will sequentially read through a table if it can't use Rushmore, however the downside is that it can be very slow.
>
>Regards,
>
>Aaron