SQL Server Handle NULL value in Where Clause

Sometime you have to select values from your SQL Server table if record has null value or not. For example I have below table in design mode and with records.


Image 1.


Image 2.

Now Write Query to Select All records

SELECT * FROM EMPLOYEE

Image 3.

Now if you want to fetch those records who have EXPERIENCE as null. You will want to write your query like below.

SELECT * FROM EMPLOYEE WHERE EXPERIENCE = NULL
SELECT * FROM EMPLOYEE WHERE EXPERIENCE = 0
SELECT * FROM EMPLOYEE WHERE EXPERIENCE < 1

Image 4.

Now write your query like below.

SELECT * FROM EMPLOYEE WHERE EXPERIENCE IS NULL

Image 5.

SELECT * FROM EMPLOYEE WHERE ISNULL(EXPERIENCE,0)=0

Image 6.

Now query to select All records where Experience is Not Null

SELECT * FROM EMPLOYEE WHERE EXPERIENCE IS NOT NULL

Image 7.