No value

From: Bulent Gumus <bgumus_at_onboard-software.com>
Date: Tue, 07 Dec 1999 23:35:19 GMT
Message-ID: <82k5jn$2o3$1@nnrp1.deja.com>

I have a table and in one column there are two discrete values "A" or "D". but some rows does not have any value. and when I say

select *
from table
where type not like 'D' and type not like 'A'

it gives "0 rows selected".

So what should I do to get the rows with no value in type column?

Thanks in advance,

--
Software Engineer
OnBoard Software Inc.
Kelly AFB, Texas
http://www.onboard-software.com/

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Dec 07 1999 - 17:35:19 CST