How To Replace Null Value With The Custom Value

COALESCE ( expression [ ,...n ] )

Example :

SELECT COALESCE(FieldName,'0.00') FROM TableName;

If The Specified Field have null value it will be replace by 0.00 in the Result.

It's equivalent to Oracle NVL.