Re: Help please !

From: Peter van Rijn <p.vanrijnREMOVE_at_THISzhew.nl>
Date: Mon, 27 Jan 2003 11:43:28 +0100
Message-ID: <v3a3ennog4nm11@corp.supernews.com>

> Replace your data types with varchar2 and do it. Betcha it works then
> Jim
>

What was this bet about;-)
It's not the datatype, but the usage of nulls that is causing the misunderstanding.

From the Concept's Manual:

<quote>
Most comparisons between nulls and other values are by definition neither true nor false, but unknown. To identify nulls in SQL, use the IS NULL predicate. Use the SQL function NVL to convert nulls to non-null values.

</quote>

In others words: in this case no records will meet your query-requirements.

hth,

Peter Received on Mon Jan 27 2003 - 04:43:28 CST