Predicate IN in WHERE clause don't work well

Article View: borland.public.vdbase.data.sql

Article #983

Back to borland.public.vdbase.data.sql Previous Next

#983

From: Paolo Bombaci
Date: Wed, 10 Jun 1998 00:00

22 lines
975 bytes

Why when I use IN predicate the SQL don't work well ?

I do this SQL :

SELECT * FROM "GRUPPI.DBF" GRUPPI WHERE NUMERO_GRUPPO IN (1,2)

The result is that are no record that are IN (1,2)

With the seguent SQL (that I think is identical to the first one)

SELECT * FROM "GRUPPI.DBF" GRUPPI WHERE NUMERO_GRUPPO = 1 OR
NUMERO_GRUPPO = 2

the result is Ok.

Why there are a difference between this two Queries that I think are
identical.

Please help me.

Thank you for your attention.

Technical Details

Message-ID: <357EA61C.6FC3@mlsys.it>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,6f1d0cffec597717,start
X-Google-Attributes: gidff5a1,public
From: Paolo Bombaci <mlsys@mlsys.it>
Subject: Predicate IN in WHERE clause don't work well
Date: 1998/06/10
Message-ID: <357EA61C.6FC3@mlsys.it>
X-Deja-AN: 361386947
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Organization: Microlab Sistemi
Newsgroups: borland.public.vdbase.data.sql