SQL Server String Functions
SQL Server string functions and descriptions of their uses.
Download optionsThe records
10 of 30 records ยท Select a column heading to sort.
| ID | Function | Description |
|---|---|---|
| 1 | ASCII | Returns the ASCII value for the specific character |
| 2 | CHAR | Returns the character based on the ASCII code |
| 3 | CHARINDEX | Returns the position of a substring in a string |
| 4 | CONCAT | Adds two or more strings together |
| 5 | Concat with + | Adds two or more strings together |
| 6 | CONCAT_WS | Adds two or more strings together with a separator |
| 7 | DATALENGTH | Returns the number of bytes used to represent an expression |
| 8 | DIFFERENCE | Compares two SOUNDEX values, and returns an integer value |
| 9 | FORMAT | Formats a value with the specified format |
| 10 | LEFT | Extracts a number of characters from a string (starting from left) |
Free sample files (up to 10 rows): CSV JSON XML
Scope and sources
Last checked against sources: October 15, 2026.
Last changed: July 17, 2026. This may reflect a change to the data or its description; it is not a coverage-through date.
A complete download includes all 30 records currently held in this dataset. Check the description and sources to decide whether its scope fits your project.
Use this dataset through the API
GET https://mysafeinfo.com/api/data/sqlserverstringfunctionsChoose a format, sort, or request fewer rows. A pass key gives access to the complete dataset. See the examples and parameters.
Without a pass, sorting and randomization apply only to the fixed 10-row sample.