Re: SQL Mystery : Bug in latest SQO32_73.DLL?

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: Wed, 06 May 1998 06:48:07 GMT
Message-ID: <35500795.1738604@www.sigov.si>

On Tue, 05 May 1998 18:09:33 -0400, Tim Romano <tim_at_superstream.net> 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.

Check if your AGENT value is left or right padded with blank, ie ' 1111' or '1111 '. If this is the case the results of your queries make sence.

>TIA,
>Tim

Regards,

---

Jurij Modic                             Republic of Slovenia
jurij.modic_at_mf.sigov.mail.si		Ministry of Finance
============================================================

The above opinions are mine and do not represent any official standpoints of my employer Received on Wed May 06 1998 - 01:48:07 CDT