TSQL (Transact-SQL) Tutorial: IS NULL Operator

The SQL Server (Transact-SQL) IS NULL condition is used to test for a NULL value.

expression IS NULL

If expression is a NULL value, the condition evaluates to TRUE. If expression is not a NULL value, the condition evaluates to FALSE.

Using - With where clause

So Let say we have multiple values in last name of employee are null and we want to get the list of those employee whose last name is null then we can write below query.

SELECT *

FROM employees

WHERE last_name IS NULL;

Expression =  null won’t behave like above is null condition it will return different results.