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

Home -> Community -> Usenet -> c.d.o.server -> Re: Setting for case-insensitve comparison

Re: Setting for case-insensitve comparison

From: Pete Finnigan <plsql_at_petefinnigan.com>
Date: Wed, 5 Nov 2003 12:36:14 +0000
Message-ID: <cwz30cA+6Oq$Qxcm@peterfinnigan.demon.co.uk>


Hi Purzel,

There is not an Oracle server setting you will need to look into the UPPER() function, used like the following

select *
from foo
where upper(something)='ABC';

kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.
Received on Wed Nov 05 2003 - 06:36:14 CST

Original text of this message

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