Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle SQL and Like Clause

Re: Oracle SQL and Like Clause

From: <apparaov_at_my-deja.com>
Date: Mon, 29 Jan 2001 17:13:40 GMT
Message-ID: <9548bq$2g9$1@nnrp1.deja.com>

you can use either of the UPPER or LOWER functions

1.Select ID from ARTICLES where UPPER(TITLE) like '%UNI%';

   OR
2.Select ID from ARTICLES where LOWER(TITLE) like '%uni%';
In article <dMD96.1292$eI2.41916_at_NewsReader>,   "JF" <john.fitzgerald_at_mainframe.co.uk> wrote:
> I can't beleive a query like the one below is
 case sensitive in Oracle
>
> Select ID from ARTICLES where TITLE like '%Uni%'
>
> will find records containing...
>
> big University
> Universally etc
>
> won't find
>
> UNISON
> universal
>
> Is there any way to use SQL with the Like
 clause in Oracle so that it's not
> case sensitive?
>
> I know that I can use interMedia indexing but
 that's overkill for what I'm
> doing, i.e. I don't want to index every
 searchable column in the db.
>
> The same query worked sweet in SQL Server!
>
>

Sent via Deja.com
http://www.deja.com/ Received on Mon Jan 29 2001 - 11:13:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US