Something like the following should solve your problem 

select nvl(A.Month_Number,'0')Month_Number from ...