How to Replace Null values with Unknown in Select Statement - SQL Server / TSQL Tutorial Part 111

SQL Server / T-SQL Tutorial Scenario:
You are working as SQL Server developer, you need to query dbo.Customer table and replace Null values in Name column to "Unknown Name". Which SQL functions will you use to replace Null value with "Unknown Name"?

Link to scripts used in SQL Server / T-SQL Tutorial Video

Check out our website for Different SQL Server, MSBI tutorials and interview questions
such as SQL Server Reporting Services(SSRS) Tutorial
SQL Server Integration Services (SSIS) Tutorial
SQL Server DBA Tutorial
SQL Server / T-SQL Tutorial ( Beginner to Advance)