Can anyone clearly explain what the difference between null and nothing? On the 100 question quiz it states that null in sql represents nothing but I have also read that a null is an uninitialised variable and can be tested for using isnull(var) and nothing is nothing and can be tested for using isnothing(var). So what is the difference between null and nothing??
Thanks