How to Use NULL in SQL server Query ?

Dear Friends,  If a column has the value NULL , if you want to use Null in your query , then use the word IS instead of =.  


Let us explain how to use in query


Select * from table1 where month=Jan


Select * from table1 where month IS NULL