Hi David, the field is not limited to numeric values.
The following query, where comp is an varchar field, as executed from Tersus:
SELECT * ROM qrtprojectenri_auth WHERE comp>=650 AND comp<=650 ORDER BY id LIMIT 20
returns the resultset within 50 seconds, I tested this query also directly in mysql with the same result, but executing the same query with a small change "650":
SELECT * ROM qrtprojectenri_auth WHERE comp>="650" AND comp<="650" ORDER BY id LIMIT 20
returns the resultset within 2 seconds.
For best results, use the Firefox browser..