Re: Case insensitivity in LIKE query - possible?

From: Christian Dethlefsen <chrd_at_novo.dk>
Date: 1996/03/31
Message-ID: <315E95C7.4ACC_at_novo.dk>#1/1


James P. Cooper wrote:
>
> Hello,
>
> I'm using Oracle 7.1 on an SGI, and would like to perform some case
> insensitive queries using LIKE. I've looked through several SQL books,
> and have found nothing addressing the subject. Can this be done?
>
> Currently the query:
>
> SELECT * from foo where name LIKE 'James';
>
> will match:
>
> James
> James Cooper
>
> but not:
>
> JAMES
>
> ...
>
> Any suggestions appreciated.
>
> -- James
>
> .........................................................................
> James Paul Cooper * Pixel
> MU College of Education
> pixel_at_coe.missouri.edu - http://tiger.coe.missouri.edu/~pixel/
> .........................................................................
I think that the functiom UPPER is well known to everybody following this group. What is needed is to have Oracle to think about the problem and come up with a function that does case insensitive queries and still using indexes.

Regards Chr. Dethlefsen Received on Sun Mar 31 1996 - 00:00:00 CET

Original text of this message