When you want to replace a possibly null column with something else, use IsNull.

When you want to replace a possibly null column with something else, use IsNull.


SELECT ISNULL(myColumn, 0 ) FROM myTable