NULL value can be dangerous

NULL can be produce weird results and sometimes it is hard to diagnose the root cause. So to avoid such a problem like this you need to remember few things before you write a query. There are several ways to overcome this solution here I will discuss only

http://wiki.asp.net/