Posted by Alexander Kuznetsov on 04/11/06 19:07

verify your ansi_nulls settings:

create table #t(i int)
insert into #t
select null
union all
select 1
union all
select 2
union all
select 3
go
select i from #t where i not in(1)

i
-----------
2
3

(2 row(s) affected)
go
set ansi_nulls off
go
select i from #t where i not in(1)

i
-----------
NULL
2
3

(3 row(s) affected)

go
drop table #t

[Back to original message]