|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
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