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, and to convert strings to lowercase or uppercase.
SQL String Functions
The following table will show you the list of available SQL String Functions
| SQL String Functions | Description |
|---|---|
| ASCII | It will return the ASCII code of the left most character of a character expression. |
| CHAR | It will convert the integer value (ASCII code) to a character |
| CHARINDEX | It returns the index position of a specified expression |
| CONCAT | It is used to combine two or more strings and returns string. |
| DIFFERENCE | It will return the difference between the SOUNDEX values of the specified character expressions |
| FORMAT | It will format the expression with the specified format. |
| LEN | It is used to find the length of a specified expression |
| LEFT | It is used to return left most characters from the specified expression |
| LTRIM | It removes the empty spaces from Left side of a character expression |
| LOWER | It is used to convert the given text, or expression to Lowercase |
| NCHAR | It is used to return the Unicode character at the specified integer value |
| QUOTENAME | It will return the Unicode string with the delimiters |
| REPLACE | We can use this function to replace the existing string with new string value. |
| REPLICATE | It will repeat the existing string for given number of times. |
| REVERSE | It is used to reverse the specified expression |
| RIGHT | It will return the right most characters from the specified expression |
| RTRIM | It is used to remove the empty spaces from the Right hand side of a character expression. |
| PATINDEX | It is used to return the starting index position of the first occurrence of a pattern in an expression. |
| SOUNDEX | It 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 | It is used to split the character expression using the separator. |
| SUBSTRING | It returns specified number of characters from the given expression. |
| UNICODE | It is used to return the Unicode (integer) value, as defined in Unicode standards. |
| UPPER | This function will convert the given text, or expression to Uppercase |
People who want to save it as the Image:
Thank You for Visiting Our Blog
I would like to thank you for sharing the valuable information regarding SQL Server step by step.
Can you please post an article about CTE and sub queries if possible.
I appreciate your hard work.
We will do as soon as possible.
Please refer
For Subqueries : https://www.tutorialgateway.org/sql-subquery/
For CTE : https://www.tutorialgateway.org/sql-server-cte/