If value is null, then $0.00

• guerillaunit

  SSCarpal Tunnel

  Points: 4249

  More actions

  January 24, 2012 at 11:33 am

  #249719

  Hi there, I have a couple of money columns that sometimes have null values. I would like these null values to display $0.00. The table is cleared out and appended into everyday. Is there anyway to ensure null values are $0.00 other than to use if statements or isnull for every field?

• venoym

  SSCarpal Tunnel

  Points: 4161

  More actions

  January 24, 2012 at 11:36 am

  #1437859

  2 options.

  1. Use "ISNULL(field,0)" on each field.

  or

  2. Modify the table/load procedure to default a "0.00" on each field and mark as NOT NULL. This option will require a review of the load procedure to make sure it doesn't intentionally put NULLs in for some reason.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  January 24, 2012 at 11:46 am

  #1437868

  ISNULL - http://msdn.microsoft.com/en-us/library/ms184325.aspx

  Or Coalesce - http://msdn.microsoft.com/en-us/library/ms190349.aspx