Re: case insensitive query

Min,

     You could try using the UPPER or LOWER charcter functions:

SELECT first_name, last_name
  FROM people
 WHERE LOWER(last_name) = LOWER('Wang')    AND UPPER(first_name) = UPPER('Min');

Jay!!!

Min Wang wrote:

> Hi:
>
> How to do a case insensitive query with ORACLE8?
>
> Thanks.
Received on Tue Nov 03 1998 - 18:26:22 CST