Re: Oracle SQL and Like Clause

From: Mark Wagoner <mwagoner_at_iac.net>
Date: Thu, 18 Jan 2001 10:29:32 -0500
Message-ID: <94724t$1me0$1@genma.iac.net>

Convert the text to upper (or lower) case first.

select id from articles where upper(title) like '%UNI%'

"JF" <john.fitzgerald_at_mainframe.co.uk> wrote in message news:dMD96.1292$eI2.41916_at_NewsReader...
> 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!
>
>
Received on Thu Jan 18 2001 - 09:29:32 CST