Re: Case-insentive search

Aziz Rahman wrote:
>
> 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.

  Would you mind to tell me whether you refer to set index on street_address ?

-- 
Name        : Lun Wing San
Title       : Oracle developer of the Hong Kong Productivity Council
              System Administrator and Oracle DBA of the Quick Response
Center
Email Addr. : sunny_at_hkpc.org
Telephone   : 852-2788-5841