VFP 9 introduced the new BINARY index option. In reading the online help, I noticed that BINARY indexes can not (among other limitations) be used for SEEK's.
I assume BINARY indexes can be safely used in SQL SELECT WHERE or HAVING clauses but NOT in SQL SELECT GROUP BY or ORDER clauses. Does this seem like a valid assumption?
SELECT ... WHERE MyBinaryIndexField = somevalue
Is there a best practice list of scenarios where BINARY indexes make sense?
Thank you,
Malcolm