feature request: case insensitive indexed searches

[michael geary]

Hi Folks,

i've got a varChar field that is indexed, and I want to do 
case-insensitive searches. I know that I can do these with LIKE, but 
that doesn't use the index. Is there really no way to do something 
like:

WHERE firstname = 'ruslan' no_case

and get the benefit of using the index?

-michael