Re: Ignore Case
From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 26 Feb 2003 08:00:46 -0800
Message-ID: <92eeeff0.0302260800.46218553_at_posting.google.com>
Date: 26 Feb 2003 08:00:46 -0800
Message-ID: <92eeeff0.0302260800.46218553_at_posting.google.com>
"Mike" <chunchma_at_comcast.net> wrote in message news:<XYednRfIpuFCgcGjXTWcoA_at_comcast.com>...
> 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
Try it this way,
WHERE UPPER (CSADMIN.CLIENTS.NAME) LIKE ('%JOE%')
Regards
/Rauf Sarwar
Received on Wed Feb 26 2003 - 17:00:46 CET