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
