Case-sensitive select statements?

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.