Re: Case insensitivity in LIKE query - possible?

In article <4jf9vu$rr8_at_news.missouri.edu>,

   pixel_at_rhino.coe.missouri.edu (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
You know that you need to use 'James%' to match 'James Cooper' ?

Try Select * from foo where upper(name) like 'JAMES%';

--Paul Received on Fri Mar 29 1996 - 00:00:00 CET