Re: Oracle SQL bug in 9.2.0.8

From: DG problem <skatefree_at_gmail.com>
Date: Wed, 9 Feb 2011 17:04:24 -0800 (PST)
Message-ID: <19d34f2b-2834-44c7-ac71-d56ba304872d_at_a28g2000prb.googlegroups.com>

On Feb 10, 10:34 am, Noons <wizofo..._at_gmail.com> wrote:
> Same in 10gr2.  And I suspect it'd be the same in 11g.
> I think you've been trapped by implicit conversion in Oracle, which
> doesn't happen in the original MSSQL.
>

But there is no conversion going on. It is looking for an exact match. Also, you can see that the spaces are still present in the output.

The result displayed, 'WHY ', does not equal 'WHY'. Received on Wed Feb 09 2011 - 19:04:24 CST