>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.