Built in string functions in SQL server 2019

SQL server has a variety of string functions that are very useful for manipulating the string data type. SQL Server uses various data types to store the string and character types of data (in other words varchar, nvarchar and char). So we can use the string functions to get the desired and specific results.
concat, trim, upper,lower, replace, substring etc are most commonly used sql server built in string function.

---------------------------------------------------------