Re: SQLPlus: like and upper/lower-case
From: Ivar Stolfot <iff_at_online.ee>
Date: Wed, 1 Jul 1998 15:08:50 +0300
Message-ID: <6nd8s8$5u4$1_at_saast.uninet.ee>
Date: Wed, 1 Jul 1998 15:08:50 +0300
Message-ID: <6nd8s8$5u4$1_at_saast.uninet.ee>
Johann Tinnacher wrote in message <3599F262.57DE6B5_at_posch.com>...
>Is there a way to make the like-selection case-independent?
>
>Example:
>
>select txt
>from table
>where txt like '%TEST%';
>
WHERE UPPER(txt) LIKE UPPER(txt)
iff. Received on Wed Jul 01 1998 - 14:08:50 CEST