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 -> case independent LIKE select?

case independent LIKE select?

From: Rich Gilmour <richg_at_aaepa.com>
Date: Mon, 17 Jan 2000 17:11:25 -0800
Message-ID: <3883BDBD.A9C0A9D0@aaepa.com>


Hello all.

I'm trying to write a search function which has the ability to perform a LIKE search for keywords in article titles regardless of case. I have no problem doing this if I specify the correct case, but no go if I don't enter proper capitalization. Could someone please show me the proper syntax to pull this off?

Thanks in advance,

Rich Gilmour Received on Mon Jan 17 2000 - 19:11:25 CST

Original text of this message

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