Home » SQL SERVER » SQL Functions » String Functions

String Functions

SQL Server string functions are used to manipulate with string data.

SQL Server STRING_AGG Function

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.

SQL Server STRING_SPLIT Function

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

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.

Syntax

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

SQL TRANSLATE()

 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.