facticatech (1/12/2011)

---

I have set of columns (more than 10) and need to update them to 0 if it is null.

for eg: update table set column1=0 where column1 is null

update table set column2=0 where column2 is null

............

............

............

update table set column10=0 where column10 is null

Is there a better way to write in a single statement instead of 10 statements like the one above for 10 different columns?