Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: case independent LIKE select?

Re: case independent LIKE select?

From: George P. <george.pierceNOgeSPAM_at_wcom.com.invalid>
Date: Tue, 18 Jan 2000 10:55:40 -0800
Message-ID: <0d24a28c.6778a418@usw-ex0107-050.remarq.com>


Unless I am missing something, you will just do a simple select statement as follows:

select *
from article_table
where UPPER(article_title) like 'UPPER(input_str)%';

Received on Tue Jan 18 2000 - 12:55:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US