How to do case-insensitive SELECT?

Philip Greenspun's Homepage : Philip Greenspun's Homepage Discussion Forums : 6916 : One Thread
Notify me of new responses
I'm trying to find a way to make my SELECT statement in PS1 Ex#8
case-insensitive. If I do

select * from quotations where author_name like '%bill%';

the Bill Gates quote does is not selected since the 'b' is lowercase.

I've looked a bit in oradoc and also at SQL for Web nerds, so far
with no luck.

Could you give me suggestion or hint?

-- Andrew Grumet, September 17, 1999

Answers

Try the sql function lower

Lower takes a string input and returns the all lowercase version of that string. The function Upper may also be helpful.

-- Jesse Koontz, September 17, 1999