String manipulation is a process to generate another form of existing data in a way the business uses or displayed as results in the reports. Previous SQL string function articles, I have written, including SQL string functions for Data Munging and SQL Substring function overview discussed data preparation and data management tasks using built-in SQL Server string functions.
After reading this article, you’ll understand:
- What is a NULL
- Understand the data
- Discuss SQL Server Coalesce() function
- SQL Coalesce with a string concatenation operation
- SQL Coalesce and pivoting
- Scalar user-defined function and SQL Coalesce function
- Data validation using SQL Coalesce function
- SQL Coalesce with computed columns
- SQL COALESCE and CASE expression
- And more…
further reading….