Mike,

>
>LOCATE FOR FIELD1=SOMETHING AND FIELD2=SOMETHING

Sometime (not always) we can do:

set near on
seek something
scan rest while FIELD1=SOMETHING for FIELD2=SOMETHING
endscan

>
>You'll need three index tags to do what you suggest. The best practice is to use SQL and have the two indexes and not to grab more data than necessary.

Deal.. Completely correct !! :)

Just an addedum.. BINARY SEARCH (by index) will be many times faster than SEQUENTIAL SEARCH.. So, there is some moments that SQL will be the "wild thing".. (If we don´t have the properly key for that search)

Claudio