Re: SQLPlus: like and upper/lower-case
From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 1 Jul 1998 16:07:02 GMT
Message-ID: <6ndmr7$42b2_at_hendrix.csufresno.edu>
Date: 1 Jul 1998 16:07:02 GMT
Message-ID: <6ndmr7$42b2_at_hendrix.csufresno.edu>
In article <3599F262.57DE6B5_at_posch.com>,
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.
Use: where UPPER(txt) like '%TEST%'
But beware, using Upper (or % in front of the value) causes a full table scan, so don't use it on large tables unless another part of the where clause enables use of an index.
Steve Cosner Received on Wed Jul 01 1998 - 18:07:02 CEST