SQL Server PATINDEX function is a string function that returns the starting position of the first occurrence of a pattern in a specified expression.
SQL Server STRING_AGG() Function is string function which concatenates values for any given string expressions and separate them a specified separator.
It does not add the separator at the end of the result string.
String expression values are implicitly converted to string types and then concatenated.
The SQL Format function is a SQL Server string function which is used to format the specified value in the given format such as to format the date/time values and number values.
SQL Server REVERSE Function is a string function that returns the reverse order of a string value. It returns a value of type varchar or nvarchar .
SQL Server CONCAT_WS() function is a string function that is used concatenates two or more strings together with a separator.
It separates those concatenated string values with the delimiter specified in the first function parameter.
SQL Server STRING_SPLIT function is used to split a string into a table that consists of rows of substrings based on a specified separator. This function was introduced in SQL Server 2016 .
STRING_SPLIT requires the compatibility level to be at least 130. When the level is less than 130, SQL Server is unable to find the STRING_SPLIT function.
SQL STUFF() function is used to delete a sequence of given length of characters from a string and inserting the given sequence of characters from the specified starting index.
STUFF(String, Start, Length, Newstring)
String – It is the string to be modified.
Start – The starting index from where the given length of characters will be deleted and new sequence of characters will be inserted.
Length -The number of characters to delete from string
The SQL TRANSLATE() is a string function that is used to replaces a sequence of characters in a string with another sequence of characters.
The function replaces a single character at a time. Until SQL Server 2016, we used use REPLACE() function to replace each character.
SQL SPACE() is a string function that replicates the number blanks that we want add to the given string.
SQL REPLICATE() Repeats a string value a specified number of times.
SQL Server 2017 has released a new TRIM() function that is used to remove both Leading and Trailing spaces from any given string.
SQL UPPER() function converts all the characters in a string into uppercase.
SQL CHARINDEX() function searches for a substring inside a string starting from a specified location.
SQL SUBSTRING()functions extracts a substring with a specified length starting from a location in an input string.