SQL QUOTENAME Function
SQL QUOTENAME function is a string function which returns a Unicode string with the delimiters added to make the input string a valid SQL Server… Read More »SQL QUOTENAME Function
Home » SQL SERVER » SQL Functions »
String Functions
SQL Server string functions are used to manipulate with string data.
SQL Server PATINDEX
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
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 Format Function
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
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
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 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.
SQL SPACE
SQL SPACE() is a string function that replicates the number blanks that we want add to the given string.
Syntax
SPACE(number)
SQL TRIM()
SQL Server TRIM() function is used to remove both Leading and Trailing spaces from any given string It was introduced in SQL Server 2017 version… Read More »SQL TRIM()
SQL CHARINDEX()
SQL CHARINDEX() function searches for a substring inside a string starting from a specified location.
SQL SUBSTRING()
SQL SUBSTRING()functions extracts a substring with a specified length starting from a location in an input string.
SQL DATALENGTH Function
SQL DATALENGTH() function is used to return the number of bytes used to represent a given string.
SQL Server RTRIM()
SQL Server RTRIM() function is used to trim trailing characters from a character string.
SQL Server LTRIM()
SQL Server LTRIM() function is used to trim leading characters from a character string.
SQL SERVER REPLACE
SQL REPLACE() function is used to replace all occurrences of a substring in a string with a new substring .
