Will null evaluate with null(null = null)

Post

View All

Vinay Talapaneni

Will null evaluate with null(null = null)

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

By Vinay Talapaneni in SQL Server on Aug 31 2020

2
1.4k
1

Post Your Answer

Sep, 2020 14
the result of null = null is not true but unknown. null is not equal ( = ) to anything—not even to another null
- 0