Re: IN and NULL

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 10 Feb 2000 16:02:58 -0800
Message-ID: <38a351b2@news.victoria.tc.ca>

: >
: >Having a bit of a wrestle trying to get this statement to work in
: >Oracle 8:
: >
: >SELECT *
: >FROM products
: >WHERE product IN ('Nuts and Bolts', NULL)
: >AND category IN ('Hardware', NULL)
: >
: >It just appears to ignore the NULL condition. Replacing NULL with
: >'' doesn't help either.
: >

select * from products
where
NVL(product,'This is not a product name') IN ('Nuts and Bolt','This is not a product name'); Received on Thu Feb 10 2000 - 18:02:58 CST