Case sensitive

Hi

Someone knows if/how is it possible to look at text data in a case insensitive way?

Eg:

$ insert into t1 (name) values ('Mary Ann');
$ insert into t1 (name) values ('MARY SMITH');
$ select name from t1 where name like 'Mar%';
$ rem this would get both records.

options:

1. put all text in CAPITALS => my users don't want it
2. use " where upper(name) like 'MAR%' " => performance problems...
   ->3. define somewhere/somehow/someoption in oracle server ?????
   
3. ?

Thanks in advance
  Antonio

ps: please also reply directly to my e-mail

-- 
---__                                                                      
  /. \__  Antonio Melo  (SW Engineer)                            
  \__/. \ (avm_at_novabase.pt)                                                
  /. \__/ NOVABASE - Sistemas de Informacao e Bases de Dados, SA.          
  \__/    Av. Antonio Jose' de Almeida, 5-F, andares 6 e 7                 
1000 LISBOA - PORTUGAL (Phone: 351.1.7959157  Fax: 351.1.7959188)