Re: SQLPlus: like and upper/lower-case
Date: Wed, 01 Jul 1998 14:44:00 +0200
Message-ID: <359A2F0F.B0F47C69_at_memo.volvo.se>
You are able to do something like this:
select txt
from table
where upper(txt) like '%TEST%';
This makes oracle thinks that all letters is uppercase, there is a
function lower for lowercase also.
/ Ola
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.
>
> (oracle workgroup server 7.1.6, sqlplus 2.1.6)
>
> -----------------------------------------------
> Ing. Johann Tinnacher <j.tinnacher_at_posch.com>
>
> Posch Ges.m.b.H. Tel. +43/3452/82954-35
> 8430 Leibnitz Fax +43/3452/73389
> -----------------------------------------------
Received on Wed Jul 01 1998 - 14:44:00 CEST