Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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
![]() |
![]() |