Creating Understanding and Educating Programmers, Developers and Technical Communities, one post at a time.

Monday, March 21, 2011


Earlier, I posted blog on T-SQL ISNULL() function. I realized that it is not good idea to post something before sharing knowledge on NULL.

NULL is considered as unknown and result of any expression that include null is also unknown. It is good idea to test null to avoid unknown result. SQL provide IS operator to test null value.

WHERE Expression IS NULL