Will null evaluate with null(null = null)

Vinay Talapaneni

1.5k

Yes, After changing default ansi_null setting null can evaluate with null. Check the below code for reference.
select 1 where null = null
go

set ansi_nulls off
go
select 1 where null = null
go

the result of null = null is not true but unknown. null is not equal ( = ) to anything—not even to another null