The SQL Server provides various SQL String Functions, which allows us to alter the individual characters in a string, compare strings, search strings, extracting sub strings, copy of string. You can also use these SQL String Functions to convert strings to lowercase or uppercase.
This article shows you the available list of Sql Server string functions and their definitions.
SQL String Functions
The following table will show you the list of available SQL String Functions. Use those links to see the practical example for each one of them.
| SQL String Functions | Description |
|---|---|
| ASCII | It returns the ASCII code of the left most character of a character expression. |
| CHAR | Convert the integer value (ASCII code) to a character |
| CHARINDEX | It returns the index position of a specified expression |
| CONCAT | Combine two or more strings and returns string. |
| CONCAT_WS | This function concatenate two or more string using separator. |
| DIFFERENCE | Return the difference between the SOUNDEX values of the specified character expressions |
| FORMAT | Format the expression with the specified format. |
| LEN | To find the length of a specified expression |
| LEFT | Returns the left most characters from the specified expression |
| LTRIM | It removes the empty spaces from Left side of a character expression |
| LOWER | This Sql Server string function convert the given text, or expression to Lowercase |
| NCHAR | It return the Unicode character at the specified integer value |
| QUOTENAME | It return the Unicode string with the delimiters |
| REPLACE | We can use this function to replace the existing string with new string value. |
| REPLICATE | Repeat the existing string for given number of times. |
| REVERSE | Helps to reverse the specified expression |
| RIGHT | Return the right most characters from a given expression |
| RTRIM | It removes empty spaces from the Right hand side of a given expression. |
| PATINDEX | It is used to return the starting index position of the first occurrence of a pattern in an expression. |
| SOUNDEX | This function returns the SOUNDEX code. |
| SPACE | It is used to return the string of repeated spaces. |
| STR | It returns the string representation of the numeric expression. |
| STRING_ESCAPE | This function will escapes the special characters from the text. |
| STRING_SPLIT | Split the character expression using the separator. |
| SUBSTRING | It returns specified number of characters from the given expression. |
| TRIM | Remove the empty spaces from both right and left side of a string expression. |
| UNICODE | Return the Unicode (integer) value, as defined in Unicode standards. |
| UPPER | This function convert the given text, or expression to Uppercase |
People who want to save this SQL string functions in their mobiles can use this Image:
