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
2,663 total views, 2 views today
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.
2,219 total views, 1 views today
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.
8,872 total views, 2 views today
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.
2,498 total views, 1 views today
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 .
1,449 total views, 1 views today
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.
2,163 total views
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.
7,019 total views, 1 views today
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
1,782 total views, 2 views today
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.
1,832 total views
SQL SPACE
SQL SPACE() is a string function that replicates the number blanks that we want add to the given string.
Syntax
SPACE(number)
1,040 total views, 1 views today
SQL REPLICATE()
SQL REPLICATE() Repeats a string value a specified number of times.
1,201 total views, 2 views today
SQL TRIM()
SQL Server 2017 has released a new TRIM() function that is used to remove both Leading and Trailing spaces from any given string.
2,652 total views, 1 views today
SQL UPPER()
SQL UPPER() function converts all the characters in a string into uppercase.
1,168 total views, 2 views today
SQL CHARINDEX()
SQL CHARINDEX() function searches for a substring inside a string starting from a specified location.
1,754 total views
SQL SUBSTRING()
SQL SUBSTRING()functions extracts a substring with a specified length starting from a location in an input string.
1,443 total views
SQL DATALENGTH Function
SQL DATALENGTH() function is used to return the number of bytes used to represent a given string.
1,529 total views, 1 views today
SQL Server RTRIM()
SQL Server RTRIM() function is used to trim trailing characters from a character string.
1,129 total views, 2 views today
SQL Server LTRIM()
SQL Server LTRIM() function is used to trim leading characters from a character string.
1,043 total views, 2 views today
SQL SERVER REPLACE
SQL REPLACE() function is used to replace all occurrences of a substring in a string with a new substring .
1,495 total views
SQL LOWER()
SQL LOWER() function converts all the characters in a string into lowercase.
964 total views