Re: Case-insentive search
From: Neill Atkins <natkins_at_uk.oracle.com>
Date: 1996/11/13
Message-ID: <01bbd131$d3cdc060$4092038a_at_ukp2394.uk.oracle.com>#1/1
Date: 1996/11/13
Message-ID: <01bbd131$d3cdc060$4092038a_at_ukp2394.uk.oracle.com>#1/1
What about using hints ??
-- Neill Atkins ... Me, Myself, I - Opinions etc etc .. Aziz Rahman <arahm_at_ctp.com> wrote in article <568m7b$3q5_at_concorde.ctp.com>...Received on Wed Nov 13 1996 - 00:00:00 CET
> We are trying to perform a case-insensitive search on a specific column
> of a table, e.g.
>
> select cust_name from customer
> where upper(street_address) like upper('pattern%');
>
> Both street_address and pattern are in mixed case. But we also want to
be
> able to use the index on street_address. Is this possible ? Any
> suggestions or comments will be greatly appreciated.
>
>
> - Aziz Rahman
>
>