NULL isn't the same as
'NULL' (one is the absence of a value, one is the string with letters N, U, L and L), so replacing it like that doesn't work.
Try using the
SELECT ISNULL(a.[BPOAGE], 0) AS BPOAGE , a.[BPOAttic] FROM [Legacy].[dbo].[MyTables] as a