Re: String Search in Oracle Database
From: Daniel Cox <DCox_at_mailexcite.com>
Date: 1999/02/11
Message-ID: <36C217B8.8A934E8E_at_mailexcite.com>#1/1
Date: 1999/02/11
Message-ID: <36C217B8.8A934E8E_at_mailexcite.com>#1/1
no,
NOTE: running an SQL function on a field can prevent the use of indexes
for some fields it is worth storing the original and an upper case version of
the text, using a trigger to make sure the upper case version is always correct
then
Lim Wee Shoong wrote:
> Hi,
select * from tbl where upper(fld) like 'A%';
will find everything containing a, upper or lower case
select * from tbl where ufld like 'A%'
>
> Thanks for all the replies. But I just want to check if UPPER will work for
> wildcard search,
> that is, can I do a UPPER ( a%) to search for everything containing a, be
> it uppercase or lowercase.
>
> Thanks, wee shoong
Received on Thu Feb 11 1999 - 00:00:00 CET