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. ?

User a before update trigger with pl/sql-code   :new.name=Upper(:old.name)
and also an insert-trigger which does the same thing.

after this the name will be in CAPITALS.

hope that helps

Hans-Juergen Received on Wed Nov 13 1996 - 00:00:00 CST