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 Sensitivity in select

Case Sensitivity in select

From: Stu <stu_at_dkmsoft.com>
Date: Thu, 26 Aug 1999 12:28:42 +0100
Message-ID: <37C524EA.CC828BE7@dkmsoft.com>


Is it possible to set a parameter which will make a select statement case insensitive. i.e. so that select * from words where word='hello' will bring back records where word='HELLO' or 'Hello'. Received on Thu Aug 26 1999 - 06:28:42 CDT

Original text of this message

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