Xref: alice comp.databases.oracle.misc:34379 Path: alice!news-feed.fnsi.net!hammer.uoregon.edu!logbridge.uoregon.edu!join.news.pipex.net!pipex!plug.news.pipex.net!pipex!bore.news.pipex.net!not-for-mail From: "Jim" Newsgroups: comp.databases.oracle.misc Subject: Re: how to ignore case under Oracle? Date: Wed, 23 Jun 1999 22:38:43 +0100 Organization: UUNET WorldCom server (post doesn't reflect views of UUNET WorldCom Lines: 34 Message-ID: <7krkk5$cld$1@lure.pipex.net> References: <376E9DB8.5A042FF4@erols.com> X-Trace: lure.pipex.net 930174405 12973 62.188.137.27 (23 Jun 1999 21:46:45 GMT) X-Complaints-To: abuse@uk.uu.net NNTP-Posting-Date: 23 Jun 1999 21:46:45 GMT X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2014.211 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211 Only thing to watch out for is that Oracle (as of ver 7, haven't used 8 myself) disables indexes on functions i.e select * from my_table where upper(surname) = 'SMITH'; will disable any index on the surname column (I think it also happens if it's part of a composite index). If it's a problem you could have something like a SurnameEntered column and a SurnameUpper (which you could use to search on). You really need to watch out when using the TRUNC function to strip the time component out of dates that only go in as SYSDATE. adrien wrote in message news:376E9DB8.5A042FF4@erols.com... > Convert you strings to upper case : select upper(column_name) from... > > > Jason Coleman wrote: > > > Hi all, > > > > I'm still pretty new with Oracle. Hoepfully this is a nice basic > > question. I've primarily dealt with Access and SQL Server so it hasn't > > been an issue with me before. How do I do a case insensitive string > > compare in the WHERE clause under Oracle? I can't seem to find a mention > > in the documentation anywhere. All the examples use data which is all > > lower case or all uppercase so it never seems to deal with that. I feel > > dumb asking, but I've fiddled around with it for enough hours I'm feeling > > dumb anyway. :) > > > > Thanks! > > Jason >