By the way... I'd like to ask.. what do you think

INDEX ON Upper(Description) TAG Test1
INDEX ON "1"+UPPER(Description) TAG Test2


SELECT * FROM table WHERE "1"+UPPER(Description) LIKE "1%X%C" INTO ARRAY laResult
Take 30 seconds...
SELECT * FROM Table WHERE UPPER(Description) LIKE "%X%C" INTO ARRAY laResult
Take 27 seconds...
SELECT * FROM Table WHERE UPPER(Description) LIKE "X%C" INTO ARRAY laResult
Take 4 second....!!!

In 3-rd case - it same "Partial" but speed of query realy nice... is there some trick to avoid lead "%"
in expression... or no chances?

Thanks again
Denis



>>Fabio,
>>Thank you.
>>Its realy displays FULL in VFP9.. but in VFP8S1 its always "partial" or "none"..
>>In my case I need to use "X%C" expression.. and here no chance to get it optimized.. but in any case - your message was very usefull for me.
>>
>ignore the
>>Denis.
>>
>
>The messages of SYS(3054) they are indicative only,
>there are many cases where 'partial' or 'none' it results completely optimized,
>or the SELECT is more rapids of a version 'full'