Why won't this work...

[simian336]

I have a temp table defined as

Create Table #syspreftest (
[name] varchar(255),
PreferenceValue varchar(300),
isdisabled char(1),
ItemNum char(5),
ItemDesc varchar(200)
)

I have a query that works which looks like

select preferencevalue
from #syspreftest
where isdisabled = '1'
order by preferencevalue

This also works...

select preferencevalue
from #syspreftest
where isdisabled is null
order by preferencevalue

Why won't this work...

select preferencevalue
from #syspreftest
where isdisabled <> '1'
order by preferencevalue

it just returns blanks.. (btw only 2 rows have '1' the rest don't)

Thanks

Simi

 

[IanWaterman]

Nulls can not be equated to anything.

Try

select preferencevalue
from #syspreftest
where isdisabled is null or isdisabled <> '1'
order by preferencevalue

Ian