Case-insentive search
From: Aziz Rahman <arahm_at_ctp.com>
Date: 1996/11/12
Message-ID: <568m7b$3q5_at_concorde.ctp.com>#1/1
Date: 1996/11/12
Message-ID: <568m7b$3q5_at_concorde.ctp.com>#1/1
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