Another difference is when you use "SELECT ... INTO" statement. A field that is calculated using ISNULL will have a not nullable attribute if the second argument is not nullable....