Re: String Search in Oracle Database

No,
Select * from tbl where upper(fld) like 'A%' will find everything that STARTS with a, upper or lower case....like '%A%' will find anything CONTAINING a, upper or lower case.....

Daniel Cox <DCox_at_mailexcite.com> wrote:

>no,
>select * from tbl where upper(fld) like 'A%';
>will find everything containing a, upper or lower case
>
>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
>select * from tbl where ufld like 'A%'
>
>Lim Wee Shoong wrote:
>
>> Hi,
>>
>> 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
>

To reply please remove the 'nospam' part of the address Received on Thu Feb 11 1999 - 00:00:00 CET