Re: Ignore Case
From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Wed, 26 Feb 2003 14:27:33 +0100
Message-ID: <1046266040.830109_at_news.thyssen.com>
Date: Wed, 26 Feb 2003 14:27:33 +0100
Message-ID: <1046266040.830109_at_news.thyssen.com>
"Mike" wrote...
> I'm trying to get a selct to ignore case and thought the select below
would
> return Joe or joe or any other combination that might be stored in the
> field, but isn't. Any idea what I'm doing wrong?
>
> SELECT *
> FROM CSADMIN.CLIENTS
> WHERE UPPER (CSADMIN.CLIENTS.NAME) LIKE UPPER ('%joe%')
>
> Thanks!
>
> Mike
>
Hi Mike,
your statement should work as expected. Do you have sample data for us to prove it doesn't work? What version are you on? What is the table definition?
Greetings,
Guido
Received on Wed Feb 26 2003 - 14:27:33 CET