I have a view in MS SQL 2000 which is working and showing results. There is one issue though, if there is no value for dbo.tblLeavers.fldHeadCount it shows as NULL in the results. Can I replace this with a 0 in the SELECT statment.
SELECT TOP 100 PERCENT dbo.tblHeadCount.fldCostCentre, dbo.tblHeadCount.fldDate, dbo.tblHeadCount.fldHeadCount,
dbo.tblLeavers.fldHeadCount AS fldLeavers
FROM dbo.tblHeadCount LEFT OUTER JOIN
dbo.tblLeavers ON dbo.tblHeadCount.fldCostCentre = dbo.tblLeavers.fldCostCentre AND dbo.tblHeadCount.fldDate = dbo.tblLeavers.fldDate
WHERE (LEN(dbo.tblHeadCount.fldCostCentre) > 1)
ORDER BY dbo.tblHeadCount.fldDate DESC