FWIW, I would index all fields (except Logical, Memo, General, Character (binary) and Memo (binary)) in this situation. If you let the user enter expression (Upper(Name) = "FINEBLUM"), then you may warn the user that it may take more time since this expression wont be indexed.

---

>I'm building an end user query tool similiar to the one that ships with VFP. If all fields can be searched, how do I set up the indexes? Would it be alright to just index all fields?