Hi Denis,
The problem is not the leading '%' but the fact that an index cannot be used in such case. Addin '1' at frond doesn't change that because all records start with it. You have to either build your own word table or use something like PHDbase.
>Thanks for response.
>Unfortunately AT() and $ is not optimizable...
>I try to create complex index expression like
>INDEX ON "1"+UPPER(Description) TAG Test
>and
>SELECT * FROM table WHERE "1"+UPPER(Description) Like "1%HP%PRINTER"
>to avoid not optimized lead "%"... all indexes in expression using for rushmore.. but report again "partial"..
>
>I thinking about PHD tool... for optimize query... the database is too big.. and speed of query is not acceptable now....
>
--sb--