>Hi,
>
>Could someone tell me if the LIKE clause is rushmore optimizable?
>I have an index defined as Upper(Name), where NAme is my field.
>
>My query is:
>select * from mytable where upper(name) like "%RIA%"
>
>When i use the sys(3054,1) function, it says that the query is not optimizable.
>
>Please help.
>
>Ria

If pattern in LIKE clause starts with wildcard character '%' or '_' than query isn't optimizable. Otherwise it's optimizable.

* not optimizable
select * from mytable where upper(name) like "%RIA%"

* optimizable. VFP can use index to get records that start with 'RIA'
select * from mytable where upper(name) like "RIA%"