>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.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer