id <> '2'

I have a field defined as follows:

id integer

This field normally has some value in it 1,2,3,4, but it can be null.

For example, say I have 10 records, and 5 records have values 1,2,3,4,5, but the other 5 are null

If I do a select like:

select *
from mytable
where id='2'

I get 1 record.

If I do a select like:

select *
from mytable
where id<>'2'

I get 4 records, but shouldn't I be getting 9 records?

How would i change my select to get the 9 records?

Mike Received on Wed Sep 21 2005 - 16:31:54 CDT