---
title: "How to use IS NULL in SQL Server for checking the Null value?"  
description: "How to use IS NULL in SQL Server for checking the Null value?"  
author: "Ethan Karla"  
published: 2021-09-14  
canonical: https://answers.mindstick.com/qa/93950/how-to-use-is-null-in-sql-server-for-checking-the-null-value  
category: "database"  
tags: ["database", "database management system"]  
reading_time: 2 minutes  

---

# How to use IS NULL in SQL Server for checking the Null value?

How to use IS [NULL](https://www.mindstick.com/interview/2197/is-null-a-keyword-in-java) in [SQL Server](https://www.mindstick.com/articles/12343/sql-server-2017-ctp-2-0-now-available) for checking the [Null value](https://www.mindstick.com/forum/23045/document-body-appendchild-has-a-null-value)?

## Answers

### Answer by Ashutosh Kumar Verma

**[SQL](https://www.mindstick.com/articles/202/the-detailed-concept-of-stored-procedure-in-sql-server) NULL Values :** In a database table if a column field has NULL [value](https://www.mindstick.com/articles/23219/an-optimized-description-adds-value-to-experience-and-in-turn-effectively-guest-posting-packages) it means that field has no value. When a new record in inserted in table and a column is optional and we don’t insert value in that column field then that field will saved with NULL value. **Test for NULL Values :** NULL values can not be test by comparison operators(=,>,<,<>). We can use ‘IS NULL’ and ‘IS NOT NULL’ operators for check the NULL values. **Syntax-** SELECT column1,column2,cloumn3,…. FROM tablename WHERE column IS NULL/ IS NOT NULL; Lets we have a table 'StudentData' ![How to use IS NULL in SQL Server for checking the Null value?](https://answers.mindstick.com/questionanswer/60864751-eb87-41e3-a041-47ced9fbaa78/images/b0c8667e-9c43-4353-b333-2f4ab4c2e851.png) Syntax- SELECT column1, column2,... FROM table_name WHERE column IS NULL/ IS NOT NULL **Check for IS NULL values :** Here we check the null value in the field in StudentData table. select stuAge, stuName, stuCourse from StudentData where stuCourse is null; ![How to use IS NULL in SQL Server for checking the Null value?](https://answers.mindstick.com/questionanswer/60864751-eb87-41e3-a041-47ced9fbaa78/images/52a70dcf-72a6-424d-83e1-8d79b0f6b9b7.png) **Check for IS NOT NULL values :** select stuAge, stuName, stuCourse from StudentData where stuCourse is not null; ![How to use IS NULL in SQL Server for checking the Null value?](https://answers.mindstick.com/questionanswer/60864751-eb87-41e3-a041-47ced9fbaa78/images/407c9adf-4ebf-4592-b2ac-f994638567c6.png) \
\
\
\


---

Original Source: https://answers.mindstick.com/qa/93950/how-to-use-is-null-in-sql-server-for-checking-the-null-value

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.