Re: Case sensitive ORACLE

Hi
You might use the following querry:

select name from emp where lower(name) = 'carlos'; or:
select name from emp where lower(name) = lower('CarLOs');

This form of querry might not be compatible to other databases. M$-databases for instance don't understand the 'lower'-function.

cu
  Urs

Carlserra schrieb:

> Hi:
>
> I have a problem. Oracle is case sensitive. Is there any flag or any special
> configuration to convert Oracle to not case sensitive.
>
> Example:
>
> When a use select...
>
> select name from emp where name ='CARLOS'
> select name from emp where name ='carlos'
>
> 'CARLOS' is diferent than 'carlos' but i don´t want.
> I want that 'CARLOS' = 'carlos'
>
> It's impossible?
>
> Thank you.
> CARLSERRA
Received on Fri Dec 03 1999 - 07:26:08 CST