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 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.
SQL DATALENGTH() function is used to return the number of bytes used to represent a given string.
SQL Server RTRIM() function is used to trim trailing characters from a character string.
SQL Server LTRIM() function is used to trim leading characters from a character string.
SQL REPLACE() function is used to replace all occurrences of a substring in a string with a new substring .
SQL LOWER() function converts all the characters in a string into lowercase.