Re: Case-INSENSITIVE searches?? Possible??

From: Steve Bell <swayne.bell_at_sympatico.ca>
Date: Thu, 29 Mar 2001 13:31:03 GMT
Message-ID: <3AC33724.877A401@sympatico.ca>

Hi Alex,

Another poster has answered that you can use UPPER or LOWER row functions to do this. I'll elaborate a bit with an example:

SQL> select ename from emp
  2 where ename like UPPER('bla%');

ENAME

---

BLAKE
BLAKESON
BLAKESMITH
BLAKESONSMITH SQL> Hope this helps,
Steve

Alex Skolnic wrote:

> How can I perform a case-insensitive search?
>
> I trying to perform a search on any portion of a description field
> that can be entered in Mixed case. My SQL statement is using the LIKE
> '%search%' statement, but it won't return matches that don't have the
> same case.
>
> Any ideas?
Received on Thu Mar 29 2001 - 07:31:03 CST