Re: Case sensitive

Antonio Melo wrote:
>
> 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 ?????
> 4. ?
>
> Thanks in advance
> Antonio
>
> ps: please also reply directly to my e-mail
>

4. Add an extra column to the table (upp_name) that is filled

   automatically by a before-update/before-insert trigger (uppercase    ofcourse).
5. Add `where name like 'M%' or name like 'm%'´ to your where-clauses

   (depending on cardinality of name).

--
Gert Rijs
mailto:gem_at_wirehub.net    (at home)
mailto:gert.rijs_at_corp.ah.nl (at work)