David,
For some reason UPPER makes it speedier unless something has changed in VFP 7
>Claude,
>
>If you are using ATC() there's no reason to UPPER() the memo field, it's only slowing down the performance.
>
>>I've looked at this problem extensively for things like VFP web message boards. The idea is to search info you've placed in VFP Memo fields. Started out with PhDBase which works well but will not work VFP MTDLLs and is an extra expense. The following works well without PhDBase and is probably the best you can hope for without getting into more 3rd party software:
>>ATC('SEARCHPHRASE',UPPER(MemoField)) > 0 ...