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