Re: No value

try select * from table where type is null;

cindy

Bulent Gumus wrote:

> 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 - 22:28:48 CST