I have 3 columns that need to be summed up, but any one of these can contain
a NULL value.

Col1  Col2   Col3    Col4
A     2.67    4.7     2.8
B     6.2     NULL    2.6
C     12.4    NULL    NULL

How can I sum them up to look like this?

A = 10.17
B = 8.8
C = 12.4

Thanks,
Ninel

COALESCE(Col2, 0) + COALESCE(Col3, 0) + COALESCE(Col4, 0)

Show quoteHide quote

Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, data types, etc. in
your schema are. Sample data is also a good idea, along with clear
specifications.  It is very hard to debug code when you do not let us
see it.

SELECT col1, COALESCE(col2, 0) + COALESCE(col3, 0) + COALESCE(col4, 0)
  FROM Foobar;

But you did not tell us what to do with all NULLs.  Is it zero or NULL?

Try ISNULL(Col2,0)+ISNULL( Col3,0)+ISNULL( Col4,0)

Show quoteHide quote

Aaron, Itzik - about the MIN Function
IDENTITY_INSERT
Conditional select into on temp table
Inserting data to a table from other database. Help
ISNUMERIC