select null,empty value Display in sql

select null,empty value Display in sql :

Select:

             Select  

* From Register

Select Null Value :

             

Select  *  From Register Where Name=Null

                     (Name=Null Values are Not)

            Select  *  From Register Where Name  is Null  or Name=' '

Select Null Value and Use :

        Select  *  From Register Where (Name='' OR Name is  NUll) 

                                                    and (Age is null or Age='' OR Age=0)