Re: case insenstitive

From: Harry Wild <h.wild_at_elegene.de>
Date: Thu, 19 Apr 2001 11:06:40 +0200
Message-ID: <newscache$4v71cg$qoj@delta.m.infra.net>

the Access functions corresponding to LOWER and UPPER are LCASE and UCASE.

"Carsten Landeck" <Landeck.c_at_zdf.de> schrieb im Newsbeitrag news:3ade81ea$0$4943$73bec562_at_personalnews.de.uu.net...
> 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
>
>
Received on Thu Apr 19 2001 - 04:06:40 CDT