Re: SQLPlus: like and upper/lower-case

Try

         where upper (txt) like '%TEST%';

Johann Tinnacher (j.tinnacher_at_posch.com) 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
: -----------------------------------------------

--
While DSC may claim ownership of all my ideas (on or off the job),
DSC does not claim any responsibility for them. Warranty expired when you
opened this article and I will not be responsible for its contents or use.