Re: Case-sensitive select statements?

In article <88arpc$94v$1_at_news-int.gatech.edu>,   kirk_at_kaybee.org wrote:
> I want to do:
>
> SELECT * from table where name = 'Kirk';
>
> However, I want it to return every entry where name is 'Kirk'
 or 'kirk'
> or 'kirK', etc.
>
> Is this possible?
>
> --
> 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.
>

Sure.

Something like

SELECT * from table where upper(name) = 'KIRK';

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Feb 15 2000 - 00:00:00 CST