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