Re: case insenstitive

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 19 Apr 2001 17:09:46 +0200
Message-ID: <asvtdt0nqbujevdt3rdmuft08or2veqlid@4ax.com>

On Thu, 19 Apr 2001 08:12:24 +0200, "Carsten Landeck" <Landeck.c_at_zdf.de> wrote:

>How do I make a case insensitive uqery with oracle? My old Accesss popgrams
>are just working fine when
>
>a="my" and b="MY"
>
>select * from table wehre a=b
>
>but with linked tables from oracle, access won't
>when I tried with upper it also won't work.
>
>does anybody has a clue
>
>carsten
>

This isssue has been adressed *MANY* times. Please try searching the newsgroups archives at google for replies.

Regards,

Sybrand Bakker, Oracle DBA Received on Thu Apr 19 2001 - 10:09:46 CDT