>Here is the query. >select * from search_string where lower(searchstring) like >'%"+searchTerm+"%' How the does the query compare when run without the lower function? Is it faster? You could consider creating a functional index on search_string for lower(searchstring) to help optimize the query. Roger