In Oracle SQL, there is a function NVL() that allows you to test if something is null, and then if it is, replace it with a value of your choice.
I.e.
NVL(fieldOne, 0)
Is there an equivelent function in MS SQL, I have searched the internet, but cant find anything.
I.e.
NVL(fieldOne, 0)
Is there an equivelent function in MS SQL, I have searched the internet, but cant find anything.