Case insensitivity in LIKE query - possible?

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/


.........................................................................