SQL Server Transact Basic to Expert - Replace NULL with default valueKarthikeyan Anbarasan15yPublished Jun 15, 2011, 12:00 AMUpdated Jun 15, 2011, 9:18 AM5.3k00Reactions×25BlogThis blog shows how to replace a NULL value with a default value using ISNULL in SQL ServerExample:Select Empname, ISNULL(Empsal, 0) from emptableThis will not return any null value of EmpsalCommentsJoin the conversation! Your thoughts help the community grow.Sign in to leave a commentIt is the same account you read, post and publish with — and you will come straight back to this page.Sign inCreate an account
Join the conversation! Your thoughts help the community grow.