How to convert SQL column null value to 0 and varchar to decimal in sql query

Question

I need to convert a SQL column which is in varchar datatype to decimal and the null values to 0. This is my code to convert varchar to decimal:

SELECT 
    CAST(debit as DECIMAL(9,2)),
    CAST(credit as DECIMAL(9,2)),
    sum_accname,
    sum_date, 
    sum_description
FROM 
    sum_balance

I need to convert debit and credit column null values to zero. How to insert the null value converting part to this code?

Answer 1

SELECT 
    COALESCE(CAST(debit as DECIMAL(9,2)),0) as debit,
    COALESCE(CAST(credit as DECIMAL(9,2)),0) as credit,
    sum_accname,
    sum_date, 
    sum_description
FROM 
    sum_balance