is there a way to combine these statements?
update table set field1 = 0 where field1 is NULL
update table set field2 = 0 where field2 is NULL
field1 and field2 are in the same table. however, there are instances where field1 may be NULL but field2 is not NULL (or vice versa), and i don't want to update field1 to zero when field2 is NULL.