Mike -
If you happen to set ANSI_NULLS, then it CAN be true....
Try this:
set ANSI_NULLS OFF
go
select case when NULL=NULL then 0 else 1 end
go
set ANSI_NULLS ON
go
select case when NULL=NULL then 0 else 1 end
go
set ANSI_NULLS OFF
Of course - IMO messing with ANSI_NULLS is just asking for trouble (and is a deprecated setting, so stop playing with it!!!!!!!!!), but that is an entirely different issue.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?