Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Setting for case-insensitve comparison
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
![]() |
![]() |