How to replace NULL values with ‘0’ in SQL?

Question

Can anyone explain how to replace NULL values with ‘0’ in SQL?

Answer 1

In SQL, you can use ISNULL () function to replace the NULL values with any value. Here is the syntax for replacing NULL values with zero:

SELECT ISNULL (Column_name , 0 )

FROM Table_Name;

You can also use COALESCE() function to replace NULL values and the following is the syntax for that:

SELECT COALESCE (Column_name , 0 )

FROM Table_Name;

If you want to take a course that can provide Instructor-led training and certification then sign up for this SQL Certification program by Intellipaat.

Answer 2

If you want to replace the null values with 0, you can use the ISNULL function. For better understanding here is the simple approach.

SELECT ISNULL(column_name, '0') AS ColumnName

FROM TableName;