Stil not showing up, would this have anything to do with ANSI settings within Management Studio.

From what i've read and tried the ISNULL(COUNT(*), 0) AS 'Count' should resolve this...

Many thanks for the replies, i have amended accordingly but the Field that doesn't have any records assigned to it still not appearing as NULL or 0

SELECTEV.Value AS 'Ind Type...