Hello

I want to run this sql when all the fields are integers.
"select col1, col2, (col1+col1)"

and when col1 or col2 are Null the calculated field will refer to the Null
fiedls as zero.

I try Coalesce and Cast but the calculation remain the same.

Any suggestions?
Thanks Sorin

Sorin,

> and when col1 or col2 are Null the calculated field will refer to the Null
> fiedls as zero.
>
> I try Coalesce and Cast but the calculation remain the same.

This works:

select col1, col2, coalesce(col1,0) + coalesce(col2,0) as sum from MyTable;

Regards Uli