>Hi,
>I need help to rushmore optimize query using LIKE... or maybe change sql expression code
>Example of query
>UPPER(Description) like "%HP%PRINTER" or UPPER(Description2) like "%HP%PRINTER" or UPPER(Manufacture) like "%HP%PRINTER" or UPPER(productgroup) like %HP%PRINTER"
>
>Finally.. I'v got SYS(3054) - partial.. only Deleted tag using for rushmore optimization...
>
>Any ideas how to optimize this query, or maybe another way to get same result

OK, here's a SWAG...

select nkey, upper(Description+Description2+Manufacture+productgroup) as cBig;
   from yourtable into cursor tmp

select from yourtable where nkey in (select nkey from tmp ;
   where cBig like "%HP%PRINTER"

I.e. pull the key and your description fields into a cursor, then do the LIKE search in that cursor. May be faster, I wouldn't know. I really don't have such a big table to try with.