How to handle Null value in WHERE Condition?

taaznyonker

 Profile Answers by taaznyonker Questions by taaznyonker

• Mar 31st, 2010

Use "IS NULL" to check whether value is null or "IS NOT NULL" to check the value is not NULL

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Mar 16th, 2010

You should use "IS NULL" or "IS NOT NULL" in the where clause.For example :select DEPT_NAME from DEPT where DEPT_CD IS NOT NULL;The above query returns all those department names from the table "DEPT" where the column "DEPT_CD" is not null.

Answer Question  Select Best Answer