Re: oracle upper error

From: Murf <smurphy_at_triad.rr.com>
Date: Wed, 27 Dec 2000 21:57:01 GMT
Message-ID: <92doj9$vrb$1@nnrp1.deja.com>

It depends on where you're developing at. If your SQL statement is being polled from VB, be sure and use:
...LIKE '%" & UCase$(varName) & "%'"

Here, your "v" goes into the varName variable. Notice the UCase$() instead of upper()
-Murf

In article <91neb9$hgm$1_at_nnrp1.deja.com>, mikeys_at_web.de wrote:
> Hi there.
>
> I've got the following sql statement on an oracle db:
> select USR_SURNAME from USR_USERINFORMATIONS where upper(USR_SURNAME)
> like upper('%v%');
> When I start this statement I got all surnames which contains "v".
> That's right. But I also get the surnames which contains "ö" an
no "v".
> The same error is given when I search after "ä", "ö" or "ü".
>
> Is this an oracle bug ?
> Any Solutions ?
>
> Please help me !
> Mike.
>
> Sent via Deja.com
> http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Wed Dec 27 2000 - 15:57:01 CST