Good point! I'm sorry but I meant to say $ versus AT(). The search they do is case sensitive, so I didn't mean to compare the $ to the ATC(), but rather the AT() command.

Thank you for your feedback!

-Don

>>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,
>Without testing it, I would think it would slow it down. AT() would be the equivalent. ATC() does a case-insensitive search. Both AT() and $ are case-sensitive.
>
>Searching on memos is likely to be slow no matter what you do.
>
>Regards.