Re: Case-sensitive select statements?

K Stahl <BlueSax_at_unforgettable.com> wrote:
:> > where name = upper('Kirk')
 

: This could cause problems if there is an index on the column 'name'.

Why? It would slow down the search excessively?

Here is my problem. I want to be able to reproduce their username with the same case they entered it in. However, I want it to be case insensitive.

I got one useful email, basically (as I'm doing this in a stored procedure), I can convert both strings to upper (as the search string will be passed in via a parameter):

select * from users where UPPER(name) = UPPER('Kirk')

However, this search would have to be done on every user login. Maybe, in this case, it would be more efficient to store their username in the database twice: once maintaining case, and once in lower case for searches?

-- 
 Kirk Bauer -- CmpE, Georgia Tech -- kirk_at_kaybee.org -- Avid Linux User
    GT Sport Parachuting Club!  http://cyberbuzz.gatech.edu/skydive
     Opinions expressed are my own, but they should be everybody's.