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.

Look up the Nz Function

Look up the Nz Function

Great. Just what I was after. Thanks.