>>Anybody know of any methodologies to improve the speed of a contained in search.
>
>Would you please be more specific for what exactly you're trying to achieve and what have you tried so far?
>
>Here is one thread that may be relevant
>Re: SQL LIKE and Rushmore optimization Thread #1088808

I know that I can't optimize a "contain in" search. ( "ABC" $ field or Field LIKE "%ABC%". ) I was asking about some other way(s) to beat the system. I am currently testing with FoxWeb Full Text Search Class and so far so good.

Mike