Re: Oracle SQL and Like Clause

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