Re: case insensitive query

Min,

If you use the UPPER or LOWER functions on your fields, then you get a case insensitive query. Something like:

select count(*) from your_table
where UPPER(field_one) = 'ABC';

Hope this helps,

Gene Plagge

Min Wang wrote in message <363F5E48.E3AC80EA_at_colorbank.com>...
>Hi:
>
>How to do a case insensitive query with ORACLE8?
>
>Thanks.
Received on Wed Nov 04 1998 - 12:57:17 CST