SQLPlus: like and upper/lower-case
From: Johann Tinnacher <j.tinnacher_at_posch.com>
Date: Wed, 01 Jul 1998 10:25:31 +0200
Message-ID: <3599F262.57DE6B5_at_posch.com>
[Quoted] [Quoted] Is there a way to make the like-selection case-independent?
[Quoted] Ing. Johann Tinnacher <j.tinnacher_at_posch.com>
Date: Wed, 01 Jul 1998 10:25:31 +0200
Message-ID: <3599F262.57DE6B5_at_posch.com>
[Quoted] [Quoted] Is there a way to make the like-selection case-independent?
Example:
select txt
from table
where txt like '%TEST%';
[Quoted] [Quoted] where txt can be 'TEST', 'test' etc.
[Quoted] (oracle workgroup server 7.1.6, sqlplus 2.1.6)
[Quoted] Ing. Johann Tinnacher <j.tinnacher_at_posch.com>
Posch Ges.m.b.H. Tel. +43/3452/82954-35 8430 Leibnitz Fax +43/3452/73389Received on Wed Jul 01 1998 - 10:25:31 CEST
-----------------------------------------------