Hello Ria

I have done some reading on the subject, I am not "The Guru"

I would have to say no


>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