Re: SQLPlus: like and upper/lower-case

Johann Tinnacher wrote:
>
> Is there a way to make the like-selection case-independent?
>
> Example:
>
> select txt
> from table
> where txt like '%TEST%';
>
> where txt can be 'TEST', 'test' etc.
>

Actually, to expand on this: Is there a way to set a mode in which Oracle is case-insensitive?

Otherwise, you are forced to always account for the case of a value, unless you KNOW it is in the correct form.

Also, doesn't using the case functions negate the index?

Thanks,  

Geoff Houck
systems hk
hksys_at_teleport.com
http://www.teleport.com/~hksys Received on Thu Jul 02 1998 - 01:17:48 CEST