In SQL Server, string functions perform character and string manipulations.
Arguments that are not string values, are implicitly converted to a text data type.
This function concatenates, or combines, first and last names.
SELECT CONCAT(FirstName, ' ', LastName) AS Name,
City, Country
FROM Customer
| Name | City | Country |
|---|---|---|
| Maria Anders | Berlin | Germany |
| Ana Trujillo | México D.F. | Mexico |
| Antonio Moreno | México D.F. | Mexico |
| Thomas Hardy | London | UK |
| Christina Berglund | Luleå | Sweden |
 |
||
These are the built-in string functions in SQL Server.
Click on a function for more details.
| Function | Description |
|---|---|
| ASCII | Returns the ASCII code value of a character |
| CHAR | Returns the single-byte character with the specified integer code |
| CHARINDEX | Returns the starting position of a string inside another string |
| CONCAT | Combines two or more string value into a single (concatenated) string |
| DATALENGTH | Rreturns the number of bytes used by an expression |
| DIFFERENCE | Returns a value measuring the SOUNDEX difference between two strings |
| FORMAT | Returns a value formatted with the specified format and optional culture |
| LEFT | Returns the left part of a string with the given number of characters |
| LEN | Returns the number of characters of a given string |
| LOWER | Converts a string to lowercase |
| LTRIM | Returns a string after it removes leading blanks |
| NCHAR | Returns the Unicode character with the specified integer code |
| PATINDEX | Returns the starting position of a pattern in a given string |
| QUOTENAME | Returns a valid SQL Server delimited string as identifier. |
| REPLACE | Replaces all occurrences of a string value with another string value |
| REPLICATE | Repeats a string value a specified number of times. |
| REVERSE | Returns a string with its characters reversed |
| RIGHT | Returns the right part of a string with the specified number of characters |
| RTRIM | Returns a string after it removes trailing blanks |
| SOUNDEX | Returns a 4-character code to evaluate the sound similarity of two strings |
| SPACE | Returns a string of repeated spaces |
| STR | Returns character data converted from numeric data |
| STUFF | Inserts a string into another string |
| SUBSTRING | Returns part of a string or binary expression. |
| TRIM | Removes spaces or other characters from start and end of a string. |
| UNICODE | Returns the integer value for a Unicode character |
| UPPER | Converts a string to uppercase. |
