I have a table that has a column called matchkey that is 16 char long text. I have indexed the full column length. I have also indexed it with only the first 5 chars. How do I tell the select clause to use the 5 character index instead of the 16 char index.
rich
