>Does anybody know of a way to rushmore optimize the following SQL
>statement?
>
>Select * from part where name like '%Cover%'
>
>I have an index on name and as long as I am searching for an equality, name
>= 'text', statement or LIKE 'Cover%', begins with, the SQL statement is
>optimized. But if I want to search for a record where the name contains a
>specified text or ends with the text, the statement is not optimized.
>
>Any help would be greatly appreciated
>
>Thanks --
>David Wilkerson
David, by definition Rushmore uses indexes to optimize SELECTs, LOCATEs, etc. Because of this, a search like yours in not optimizable. The best you can do is reduce the number of records as far as possible before you call the 'fuzzy' search.
HTH
Barbara