how to ignore case under Oracle?

From: Jason Coleman <jcoleman_at_siweb.com>
Date: Fri, 21 May 1999 13:59:05 -0400
Message-ID: <MPG.11af68f28deaf2f989686@nntp.msu.edu>

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 Received on Fri May 21 1999 - 12:59:05 CDT