I put in my vote on the wishlist. But, I'm trying to avoid the third party search if possible.

Thank,
-Don
>For the FASTEST performance consider PhDbase. It is no longer supported but can be coerced into running with VFP8. It is blazingly fast and will amaze! Also check with the VFP wish list and add your vote for a full text index.
>
>Glenn
>
>
>>Is there any difference in performance between these two commands ($ and ATC())? I currently have a rather large database (12,800 records and growing) with about 4 fields, one of which is a memo field. Each record probably has about 600-1000 characters of text in it's memo field. I have to search these memo fields for certain blocks of text. I'm using a SQL SELECT statement to retrieve the data and am using the $ to know whether or not the text they are looking for is in the memo field.
>>
>>This works fine but the customer thinks it's too slow. If I change to an ATC() instead of a $ would this speed it up? Or is there something else that might improve performance?
>>
>>Thanks,
>>-Don