Re: Case sensitive ORACLE

Try
select name from emp where name =upper'carlos';

Imtiaz

Carlserra wrote:

> 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 Mon Nov 29 1999 - 16:13:05 CST