How to update null value to zero?

Question

I want make a update query in sql-server which can update any null value to zero in a table.

Possible duplicate of [Altering a column: null to not null](https://stackoverflow.com/questions/689746/altering-a-column-null-to-not-null) — AbsoluteƵERØ, Mar 20 '18 at 07:35
Why? Null values make sense. If you don't understand them, learn how to deal with them! — jarlh, Mar 20 '18 at 07:39
@jarlh The reason is irrelevant, OP asked for a question and needs an answer ^^. — Yassine Badache, Mar 20 '18 at 07:40
@YassineBadache, OP has a problem - whatever it is - and is perhaps doing something completely wrong.' — jarlh, Mar 20 '18 at 07:43
@jarlh Yes, he has a problem. About this problem, he wants to make an update in SQL Server, which can update any `null` value to zero in a table. Could you provide OP with such an answer ? — Yassine Badache, Mar 20 '18 at 08:46

score 1 · Answer 1 · edited Mar 20 '18 at 07:53

1

This basic request will do it:

UPDATE <Table> SET <Column to update> = 0 WHERE <Column to update> IS NULL;

NB: Capital letters are not relevant.

edited Mar 20 '18 at 07:53

Yassine Badache

answered Mar 20 '18 at 07:35

Ganesh

score 1 · Answer 2 · answered Mar 20 '18 at 07:35

1

Try IFULL()

SELECT IFNULL(column_name, 0) FROM table_name;

answered Mar 20 '18 at 07:35

2 Answers2