I know that will work but is it using the 16 char index or the 5 char. I want to use the 5 char for speed.
rich ----- Original Message ----- From: "Gunnar Ekblad" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, September 24, 2003 12:44 PM Subject: [RBASE-L] - SV: Retrieving rows of a table using a partial index Have you tried : Where matchkey like 'abcde%' Pending of course your setting for quate and many Gunnar Ekblad -----Ursprungligt meddelande----- Fr�n: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] F�r rich Jasinski Skickat: den 24 september 2003 18:35 Till: RBASE-L Mailing List �mne: [RBASE-L] - Retrieving rows of a table using a partial index 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
