Re: Case insensitive query in SQLPlus?

From: Rick Jolley <rick_at_dormir.org>
Date: Fri, 3 Aug 2001 09:49:47 -0500
Message-ID: <3b6ab6cf$1_4@goliath2.newsgroups.com>

The only way I've found to do this is to lower() or upper() both sides of the where clause.

Rick

"Stan Brown" <stanb_at_panix.com> wrote in message news:9kebvu$gp2$1_at_panix6.panix.com...
> I need to be able to prepare queries (from a perl script) that will make
> case insensitive searchs on VARCAHR2 columns.
>
> This must be common, but I'm drawing a blank.
>
> Can anyone help me out here?
>
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Fri Aug 03 2001 - 09:49:47 CDT