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