Re: oracle upper error

I am not sure what you mean by "". Do you mean the function is returning null, or is there some character stripped out the message? I was not able to replicate the error.

Personally, I don't like using a function to the right of the like operator. I would try to resolve the function and pass it a literal if possible. That is I would rather see:

WHERE upper(USR_SURNAME) like '%V%'

than

WHERE upper(USR_SURNAME) like upper('%v%')   

mikeys 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/

--
Posted via CNET Help.com
http://www.help.com/