Assigning Values for null values in Sql serverselect fielda, CASE WHEN fieldb is null then 0 end as fieldb from dbo.chkTestorSELECT ISNULL( fieldb, 'Nothing' ) fieldbFROM chkTest