Re: Oracle 7.0: Case insensitive string comparisons?

In article <1d.3835.2378.0NEDDE5D_at_synapse.org> doug.hewko_at_synapse.org writes:

>NM4Michael Nolan, Tailored Software Services, Inc.
>
>NM4chrisj_at_pro-data.demon.co.uk (Chris Jack) writes:
>
> 4:Can't you make the index on _at_upper() of the column?
>
>NM4Not in a SQL-based product like Oracle. First of all, there is no
> 4_at_upper function, although there is an UPPER function. Second, I don't
> 4believe it is permitted to have index columns based on functions or computed
> 4values, they must be composed of actual columns in the table.
>

That's what you get for using a no-name database like Oracle :-). Of course, high end databases like SQLBase allow such things.

-- 
Chris Jack