Why is 0 NULL?

[Ruslan Zasukhin]

On 8/2/08 12:42 AM, "Thorsten Hohage" <thohage at objectmanufactur.com> wrote:

Hi Thorsten,

> when executing a query with a where-clause like
> 
> where quantity is not null
> 
> all rows with quantity 0 are not displayed (current Beta). Otherway
> the same "is null" also includes the "0" values.
> 
> Is this an issue with my specific DB, with the current Beta, or by
> design?

Not enough info:

* what type of column

* give please few rows as an example

* give query and selected rows.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]