>select * from ranges where alltrim(rfrom)=lvalue
>
>is index used or it is a full scan.
>

The SYS(3054) function is a good way to find out what tags are being used to optimize a query. You turn it out like this:

SYS(3054,11)

Then run your query, and you get output telling you exactly how it's being optimized.

Turn the function off with SYS(3054,0). There are actually several other choices for the second parameter-see Help.

In VFP 7, there's also a third parameter that lets you save the results to a variable rather than just displaying them in the active window. Be forewarned that you need to pass the name of a variable, not the variable itself:

SYS(3054, 11, "cResult")

Tamar