James,

>High all!

Tsk, tsk.... what a freudian slip for a police officer. *L*

VFP isn't going to be able to use the index to support the substring search like this. It could only use it to find records that start with the sequence. Is the SELECT ... LIKE "%C234%" really too slow?

Do you have some freedom with the table? Or maybe the ability to create a new one specifically to support this query?

>I am trying to search through a 1 million record table for a partial license plate number. Someone may know 3 letters of the plate number and those three letters could be anywhere in the field. I am experimenting with the code below but it is too slow. I have used all of the AT() commands and Occurs().
>The table is indexed on ALLTRIM(plate_no). Pretty much the same results. Any help would be greatly appreciated.