Re: A Question on UPPERCASE/LOWERCASE INDEXES

In article <19970514223000.SAA12235_at_ladder02.news.aol.com>,

        rjschulzsj_at_aol.com (RJSchulzSJ) writes:
> yes:
>
> create table tablename (
> fieldname char(10),
> field2 char(2)
> );
>
> create index indexname on tablename (upper(fieldname));
>
> it run´s under Oracle

I just tried this on ORACLE 6.0.35, 7.2.2.4 and 7.3.2.1, and it does NOT work.

Bill Received on Thu May 15 1997 - 00:00:00 CDT