Re: Queries give impossible results

Sorry I haven't been able to follow posts lately. I've been busy with other projects (I'm doing this because currently we don't have a real Oracle expert) and because we still has to wait the actual production environment I

haven't been able to figure this out yet. The environment I told before is a
test environment, not the production one. I mixed things because we use real
customer data in our testing environment.

I really think that this is a data related problem, because UPPER fixes the problem and customer_type LIKE 'COMPANY' AND customer_state LIKE 'ACTIVE' works fine also. I've met some problems with character sets before but nothing like this, so I actually understand if there are some of you who think that the original message was a hoax (especially when most of my messages are posted in finnish with my real name :). I have my doubts but I'll post you a solution when everything is clear. Hope that won't take longer than a week or two.

• Jake -

"Matthias Rogel" <rogel_at_web.de> wrote in message news:3DDDD2A6.9070001_at_web.de...
> Hi Jake,
>
> any news from your part of the (Oracle-)world ?
>
> matthias
>
> Jake S wrote:
> > As I explained I think we are in wrong tracks. When I figure this out,
I'll
> > post a solution with explanation. Until then we might as well concider
this
> > case closed.
> >
> > You claim me to post false messages without checking my posts to other
> > newsgroups. It's quite easy to trace someone's message history, so I
don't
> > think that was a nice thing to do.
> >
> > - Jake -
> >
> >
> >
>
Received on Fri Nov 22 2002 - 03:31:57 CST