As Barbara said, this query is not Rushmore optimizable.

Just a suggestion (I have no idea if it's better): try to use

"Cover" $ name

instead of

name like "%Cover%"

It might work a little faster.

Also, you may want to take a look at PHDBase product. It can do fuzzy searches ar incredible speed.

Vlad

>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