---

Search posts under SQL Server:

---

Records having null value in SQL Server

How to get records having null value in a column of SQL Server database table?

To retrieve all records whose a particular column value is NULL, we can use “is” keyword followed by null.

Assume that we have 4 records in the database table and we want to return only that record from the database whose LastName is null.

Execute following query in the query window.

SELECT * FROM PersonalDetails
WHERE LastName is null

This would return only one record from the PersonalDetails database table.