Loading

Replace Nulls With Specified Values in SQL Server

In this article we will see the various ways to replace null values in a table. ISNULL() function, CASE statement, COALESCE() function can be used to replace null values in a SQL Server table.

History for this article

Harpreet SinghApproved
Feb 24, 2015, 1:20 PMArticle Created
Harpreet SinghApproved
Feb 25, 2015, 12:00 AMPublished
Harpreet SinghApproved
Feb 21, 2023, 12:44 AMArticle Updated

Editorial changes — reviews, status changes and edits — are shown to the author of this article and to the editors.