Re: Case-insentive search
From: Christer Peltomaa <s93cpe_at_csd.uu.se>
Date: 1996/11/13
Message-ID: <Pine.GSO.3.95.961113185049.18841B-100000_at_ida.csd.uu.se>#1/1
SELECT * FROM EMP WHERE UPPER(ENAME) = 'BLAKE' AND (ENAME LIKE 'Bl%' OR ENAME LIKE 'bL%' OR ENAME LIKE 'BL%' OR ENAME LIKE 'bl%');
Date: 1996/11/13
Message-ID: <Pine.GSO.3.95.961113185049.18841B-100000_at_ida.csd.uu.se>#1/1
From Oracle-manual:
SELECT * FROM EMP WHERE UPPER(ENAME) = 'BLAKE' AND (ENAME LIKE 'Bl%' OR ENAME LIKE 'bL%' OR ENAME LIKE 'BL%' OR ENAME LIKE 'bl%');
Copyright (c) 1994, Oracle Corporation.
-- Christer Peltomaa, Mandat Consult AB, Stockholm, Sweden On Wed, 13 Nov 1996, Ron Jorissen wrote:Received on Wed Nov 13 1996 - 00:00:00 CET
> 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.
> >
> > - Aziz Rahman
> The solution is to create a extra column where you put the address in
> uppercase and create a index on this column.
>
>