My thanks to those of you who have pointed out that this
behavior will occur if the column values have trailing
spaces. I was unaware that Oracle SQL could be so %^$&
user-friendly! Your help is appreciated. I'm relieved to
know that this was not a side-effect of yesterday's ODBC
upgrade.
Tim
Tim Romano wrote:
>
> Running Oracle 7.3 Workgroup for NT Server.
>
> MyTable T has these columns:
>
> ID VARCHAR2(3)
> AGENT VARCHAR2(5)
>
> select * from MyTable T
> where T.ID = '059'
> and T.AGENT = '1111'
>
> returns null set. BUT
>
> select * from MyTable T
> where T.ID = '059'
> and T.AGENT = 1111
>
> returns many rows.
>
> Am I missing something very simple? Both columns are
> VARCHAR2.
> Query executed from SQL Plus 3.3. Query also executed from
> TOAD.
> Query also executed from MS-Access via ODBC. All three tools
> yield identical results.
>
> The only thing that has changed on our system was the
> installation today of Oracle's latest ODBC driver for 32-bit
> Windows, and the existing SQO32_73.DLL file was replaced as
> part of the installation.
>
> TIA,
> Tim
Received on Wed May 06 1998 - 06:26:58 CDT
