Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: rookie needs help: like operator is not working...
whoops - you know what i mean :>
Glenn Baron <gbaron_at_dial.pipex.com> wrote in article
<01beb5e3$2fd8e5e0$c886bc3e_at_default>...
> might the keyword be in UPPER case in the rows??
>
> you might need
>
> where upper('%keyword%') like upper(column_name)
>
> .. to cover all eventualities
>
> cheers
>
> Glenn baron
>
> Dominik Brammen <dominik.g.brammen_at_med.uni-giessen.de> wrote in article
> <37640FF6.38317EC3_at_med.uni-giessen.de>...
> > Hi there!
> >
> > I hope I am not posting to the wrong newsgroup. I have the following
> > problem. I want to search one column set varchar(255) with much text in
> > it for key words. My cursor-routine is working, but the LIKE operator
is
> > not working. The expression I use is like following:
> > LIKE '%keyword%'
> > but I get no result although the keyword is in many rows.
> >
> > Can anybody help me? Thanks a lot,
> > Dominik
> >
> >
> >
>
Received on Sun Jun 13 1999 - 16:53:24 CDT