Re: how to ignore case under Oracle?

From: <shiling_at_math.wayne.edu>
Date: Sat, 22 May 1999 14:27:10 GMT
Message-ID: <7i6eru$kk5$1@nnrp1.deja.com>

Try

where upper(fname)='JOHN'
or
where lower(fname)='john'

In article <MPG.11af68f28deaf2f989686_at_nntp.msu.edu>, jcoleman_at_siweb.com 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
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Sat May 22 1999 - 09:27:10 CDT