Change a NULL field to 0 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Change a NULL field to 0

Author

Topic

dr223
Constraint Violating Yak Guru

444 Posts

Posted - 2010-11-09 : 06:12:36

Hi,

I have the following cod which works perfect! However, sometimes the field YES has a NULL value, instead of writting at the output NULL, I would like it to write 0. Any help please... Many thanks

SELECT DISTINCT 
                      TOP (100) PERCENT dbo.tblProjectPatients.ProjectID, dbo.tblProjectPatients.Prac_eid, dbo.qryactiveprojects.ProjectName, 
                      dbo.tblProjectPatients.Prac_no, dbo.qryNOfPats_ByPrac_ByProj.Pats, dbo.qryNumberOf_Yes.NmbrYes AS Yes, dbo.qryNumberOf_No.NmbrNo AS No, 
                      dbo.qryNumberOf_InV.NmbrInV AS InV, dbo.qryAmountPaid.GrossAmount
FROM         dbo.tblProjectPatients INNER JOIN
                      dbo.qryactiveprojects ON dbo.tblProjectPatients.ProjectID = dbo.qryactiveprojects.ProjectID INNER JOIN
                      dbo.tblCurrSelectedProj ON dbo.qryactiveprojects.ProjectID = dbo.tblCurrSelectedProj.CurrSelected_ProjectID INNER JOIN
                      dbo.qryAmountPaid ON dbo.tblCurrSelectedProj.CurrSelected_ProjectID = dbo.qryAmountPaid.ProjectID AND 
                      dbo.tblCurrSelectedProj.CurrSelected_Prac_no = dbo.qryAmountPaid.Prac_no LEFT OUTER JOIN
                      dbo.qryNOfPats_ByPrac_ByProj ON dbo.tblProjectPatients.ProjectID = dbo.qryNOfPats_ByPrac_ByProj.ProjectID AND 
                      dbo.tblProjectPatients.Prac_eid = dbo.qryNOfPats_ByPrac_ByProj.Prac_eid LEFT OUTER JOIN
                      dbo.qryNumberOf_Yes ON dbo.tblProjectPatients.ProjectID = dbo.qryNumberOf_Yes.ProjectID AND 
                      dbo.tblProjectPatients.Prac_eid = dbo.qryNumberOf_Yes.Prac_eid LEFT OUTER JOIN
                      dbo.qryNumberOf_No ON dbo.tblProjectPatients.ProjectID = dbo.qryNumberOf_No.ProjectID AND 
                      dbo.tblProjectPatients.Prac_eid = dbo.qryNumberOf_No.Prac_eid LEFT OUTER JOIN
                      dbo.qryNumberOf_InV ON dbo.tblProjectPatients.ProjectID = dbo.qryNumberOf_InV.ProjectID AND 
                      dbo.tblProjectPatients.Prac_eid = dbo.qryNumberOf_InV.Prac_eid
ORDER BY dbo.tblProjectPatients.Prac_no