setting a null value to zero in a stored procedure

[Kangwa]

Am trying to update a table with values from another table but not all cloums are supposed to be updated so am ending up with null values how do i change these null values to zero so that the empty cloum will have zero

[azimmer]

Am trying to update a table with values from another table but not all cloums are supposed to be updated so am ending up with null values how do i change these null values to zero so that the empty cloum will have zero

use 'case':

SELECT (CASE WHEN myColumn IS NULL THEN 0 ELSE mycolumn END) as myNewColumn
...
 

[azimmer]

use 'case':

SELECT (CASE WHEN myColumn IS NULL THEN 0 ELSE mycolumn END) as myNewColumn
...
 

or better yet (standard SQL):

SELECT COALESCE(myColumn,0) as myNewColumn
...
 

[ck9663]

or better yet (standard SQL):

SELECT COALESCE(myColumn,0) as myNewColumn
...
 

select isnull(mycolumn,0)...