Show 0 if recordset value is null

[GTN170777]

Just a quick question,

I've got a recordset like --

SELECT Count(JBESSiteID) AS TotalJBESent, M.Month, SUM(JBESReceipients) AS
Emails
FROM dbo.JBESent J RIGHT OUTER JOIN Months M ON DATEPART(month, JBESDate) =
M.Month AND JBESSiteID = MMColParam AND DATEPART(year, JBESDate) =
DATEPART(year, GETDATE()) GROUP BY Month
ORDER BY Month

Which works great, but I need it to return a valu of 0 if Emails
SUM(JBESReceipients) is Null,.. any ideas?

Thanks again

 

[Bob Barrows [MVP]]

Just a quick question,

I've got a recordset like --

SELECT Count(JBESSiteID) AS TotalJBESent, M.Month,
SUM(JBESReceipients) AS Emails
FROM dbo.JBESent J RIGHT OUTER JOIN Months M ON DATEPART(month,
JBESDate) = M.Month AND JBESSiteID = MMColParam AND DATEPART(year,
JBESDate) = DATEPART(year, GETDATE()) GROUP BY Month
ORDER BY Month

Which works great, but I need it to return a valu of 0 if Emails
SUM(JBESReceipients) is Null,.. any ideas?

What database? Still SQL 2000? Always tell us please.

Anyways, this is a good situation for the COALESCE function:
, COALESCE(SUM(JBESReceipients),0) AS Emails

 

[Mangler]

ISNULL(SUM(JBESReceipients) ,0)

 

[Evertjan.]

Mangler wrote on 30 jul 2008 in microsoft.public.inetserver.asp.general:

ISNULL(SUM(JBESReceipients) ,0)

In short:

ISNULL(SUM(JBESRecipients) ,0)