SQL Server how to set a default value when the column is null

sql-server

Solution

Use case

select case 
          when user_Name is null then "default value" 
          else user_name 
       end  
from table

Problem

This is my sql in SQL server: ``` SELECT user_Name ,user_pass ,user_hometown FROM user_baseinfo ``` Sometimes the column can be null. When it is, I want to replace it with a default value.

Original source