Re: case insensitive search

Hi,
Thanks for your help.
In your case i will have to store the data in upper or lower case. How do i handle those cases where I store the data as it is.

eg:- aNuRag

when i bring up the results it should be as above but the search should be case insensitive

anurag

reply at
anurag_at_synergy-infoech.com

Suresh Bhat wrote:

> Hi -
>
> In your WHERE clause you would simply use:
>
> where upper(column1) = 'ABCDEF...... etc.' or you can use lower function
> also.
>
> This sounds too simple. Is this what you are looking for ?
>
> Suresh Bhat
>
> Anurag Minocha <anurag_at_synergy-infotech.com> wrote in article
> <377B7F36.F48D6830_at_synergy-infotech.com>...
> > Hi,
> > how do i do CaseInsensitive search on varchar2 columns .
> >
> > anurag
> >
> > reply at
> > anurag_at_synergy-infotech.com
> >
> >
Received on Fri Jul 02 1999 - 00:10:20 CDT