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