I have this query: SELECT fksiteID, SUM(SearchTypePerson) + SUM(SearchTypeLocker) + SUM(SearchTypeSpotRandom) + SUM(SearchTypePersVehicle) + SUM(SearchTypeVisitorContractorVehicle) + SUM(SearchTypeCompanyVehicle) + SUM(SearchTypeToilet) + SUM(PatrolExternal) + SUM(PatrolCarPark) + SUM(PatrolPerimeter) + SUM(PatrolInternal) + SUM(VehicleCheckAmbientLine) + SUM(VehicleCheckFridgeLine) + SUM(VehicleCheckSealChecks) + SUM(OtherChecksIDCards) + SUM(OtherChecksIncidentReports) + SUM(OtherChecksColdStoreChecks) AS NumChecks FROM [AIP].[dbo].[AAHOfficerDailyActivityReport] WHERE MonthOfReport = 6 AND RecordIsDeletedYN = 0 AND fkSiteID in (945,947,948,949,950,951,952) GROUP BY fkSiteID Which gives this result: fksiteID NumChecks 945 228 947 27 949 58 951 67 952 1015 However I want it to return: fksiteID NumChecks 945 228 947 27 948 0 949 58 950 0 951 67 952 1015 I looked on Stack Exchange and use of the NULLIF function seems like it may be helpful but I can't get it to work with this query. Any help appreciated. Graham Sivill