Skip to content
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.

Loading

SQL Server CONCAT_WS Function

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.

Loading

SQL 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.

Loading

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

Loading

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.

Loading