>First, check whether you might have a corrupted index (do a reindex).
>
>For debugging, you might look at the SQL output from the view, and try some simpler versions. Add one element at a time, or a few, to see what happens.
>

Hi,
I am not good in the SQL area, though I own the book "Taming VFP's SQL" by Tamar E. Granor but I just don't have enough time to chew it :)

What is the role of index in this case, is WHERE clause in the SELECT command processed by the order of active index?