Create a second regular index on Tic_Ticket without the filter. VFP will use that second index in it's query.

HTH

---

>I have a table with 500,000 records. I have a candidate index on tic_ticket with a filter of .not.deleted(). If I use a seek statement: =seek("901500","scticket","tic_ticket"), The record is selected immediately. If I issue a select statement: select * from scticket where tic_ticket = "901500", it takes a long time.
>
>I understand that VFP is trying to optimize the expression and it cannot optimize with the filter. Isn't there a way to tell VFP to use my tic_ticket index and not try to optimize?
>
>I am really struggling with this issue. I am beginning to come to the conclusion that I can't use select statements. But that seems crazy.