>Yes, it is decreasing speed. but than what is the solution.
>for example, in my form ,
>
>I have a textbox in which user will enter client name and then press search.
>so I wil get the records on that name like
>
>lcValue = thisform.textsearch.value
>select * from client where client!firstname = lcValue
>
>so, in above case it becomes case sensitive. that user has to enter search string in same case in what he entered.
>
>to solve this i am doing this
>
>lcValue = upper(thisform.textsearch.value)
>select * from client where upper(firstname) = lcValue
>
>if , not upper should use above then what is the other solution in above case.
>
>Thankuo
>johnstill

Create an index tag on UPPER(FirstName) then Rushmore will kick in. There are a few things that you need to keep in mind about Rushmore to use it effectively. There is an article on my web site that explains this.