Simple select statement 1

[kingstonr]

attr
-----
a
c
d
null
null

select * from tablename where attr <> 'c'

I am selecting like above from table.
In my result set I am getting only a & d.
Null values are not showing.can anybody help me how to
get the null values also.

 

[bborissov]

select * 
       from tablename
       where attr <> 'c' OR Attr IS NULL

NULL vaues are not equal AND not different than 'C' they are just DON"T KNOW values. So you must thread them very carrefuly.


Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP