|
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
Navigation:
[Reply to this message]
|