code_junkie

SQL Null set to Zero for adding

Nov 11th, 2011
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. SELECT Column1, Column2, Column3+Column4 AS [Added Values]
  2. FROM Table
  3.  
  4. SELECT Column1, Column2, IIF(ISNULL(Column3),0,Column3) + IIF(ISNULL(Column4),0,Column4) AS [Added Values]
  5. FROM Table
  6.  
  7. SELECT Column1, Column2, ISNULL(Column3, 0) + ISNULL(Column4, 0) AS [Added Values]FROM Table
  8.  
  9. nz (column3, 0)
  10.  
  11. SELECT
  12. Column1,
  13. Column2,
  14. COALESCE(Column3, 0) + COALESCE(Column4, 0) AS [Added Values]
  15. FROM Table
  16.  
  17. SELECT Column1, Column2, Nz(Column3, 0) + Nz(Column4, 0) AS [Added Values]
  18. FROM Table
Add Comment
Please, Sign In to add comment