Скачать или смотреть Practice Activity: Replacing NULL and blank values in Microsoft SQL Server

Showing a lack of data is not user-friendly. Let's see how we can change this.
My SQL Server Udemy courses are:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: https://rebrand.ly/querying-microsoft...
98-364: Database Fundamentals (Microsoft SQL Server): https://rebrand.ly/database-fundamentals
70-462 SQL Server Database Administration (DBA): https://rebrand.ly/sql-server-dba
Microsoft SQL Server Reporting Services (SSRS): https://rebrand.ly/sql-server-ssrs
SQL Server Integration Services (SSIS): https://rebrand.ly/sql-server-ssis
SQL Server Analysis Services (SSAS): https://rebrand.ly/sql-server-ssas-mdx
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): https://rebrand.ly/microsoft-powerpiv...
----
Normally data has at least one character. But what happens when you have either NULL data or blank data?
There are a variety of ways to change this data. In this video, we'll have a look at ISNULL, COALESCE, and CASE WHEN.
Why not try this as a Practice Activity? If you would like the starting code, here it is:

DROP TABLE IF EXISTS TextValues

CREATE TABLE TextValues
(txtField varchar(20) NULL)

INSERT INTO TextValues VALUES
('First value'),
('Second value'),
(''),
(NULL)