SQL Server Transact Basic to Expert - Select Query With NULL value in Column

This blog shows on the usage of NULL operator in the where condition, which doesnt pull all the empty columns or values with spaces. It will take the specified column which is unknown

Syntax:

Select  *
From table
Where Column1 is NULL

Select EmpName
From Emptable
Where Empid is Numm