Re: how to do case insensitive text literal comparison?

Try the SELECT... WHERE UPPER(COLUMN1) = 'A'

mike

Rick Lin <rlin_at_diffusion.com> wrote in article <70ouik$bo9$1_at_news1-alterdial.uu.net>...
>
> Hi,
>
> I have a row which has a VARCHAR2 column with value 'a' (for example,
> column1 VARCHAR[32]).
>
> If I want my select statements(either with column1='A' or column1='a' in
> where clause) both successfully return 'a', how do I do it in sql level?
> ...
> Rick Lin
> Diffusion, Inc.
> rlin_at_diffusion.com
>
>
>
  Received on Fri Oct 23 1998 - 00:00:00 CDT