I'm assuming you have a tag on Lower(name)? If not, you need it for Rushmore to partially optimize the select.


>I am looking for a way to speed up the following query. The table has approximately 180k records and uses the Proper() format for the name field. The query however can be part of a word.
>
>

>Select dist name,phone,address,city,state,zip From Clients;
>	Where lower(myVal) $ lower(name)
>

>
>TIA,
>
>dg