Re: rookie needs help: like operator is not working...

From: Glenn Baron <gbaron_at_dial.pipex.com>
Date: 13 Jun 1999 21:22:29 GMT
Message-ID: <01beb5e3$2fd8e5e0$c886bc3e@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:22:29 CDT