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 ...
>Hello world,
>
>How do you implement a Google-like search utility in a FoxPro application? I assume someone has figured this out already.
>
>In case my question is not perfectly clear, I will elaborate here. I want a search utility that presents the end user with a single field, in which the end user can type in one or more key worlds, hit enter, and quickly generate a results browse. The single field can accomodate individual words, phrases in quotation marks, and combinations of the two.
>
>The search results are usually right on (as good as the selected key words), and the results are delivered FAST.
>
>If you want to get fancy, you could support basic and advanced search operators like Google (see
http://www.google.com/help/basics.html and
http://www.google.com/help/operators.html).
>
>I assume someone has figured this out already. Maybe I am not finding the answer because I am not searching for the right key words! What are the right key words in FoxPro terminology?
>
>Thanks,
>
>Rick