Re: String Search in Oracle Database

You can use

select.....where upper(field_to_look_in) like 'A%';

Use A%, because the return from Upper(field_name) will be in upper case, regardless of the actual value in the field....

So, this will return any record where the field_to_look_in starts with A or a;

For an A or a in ANY spot in the field use

select.....where upper(field_to_look_in) like '%A%';

Hope it helps

Lim Wee Shoong <lweeshoo_at_starnet.gov.sg> 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 Wed Feb 10 1999 - 00:00:00 CET