| Name | Parameters | Returns | Description |
| ASCII | character_expression | int | Returns the ASCII code value of the leftmost character of a character expression |
| NCHAR | integer_expression | nchar(1) | Returns the Unicode character with the specified integer code, as defined by the Unicode standard. |
| SOUNDEX | character_expression | varchar | Returns a four-character (SOUNDEX) code to evaluate the similarity of two strings. |
| CHAR | integer_expression | char(1) | Converts an int ASCII code to a character. |
| PATINDEX | | | |
| SPACE | | | |
| CHARINDEX | | | |
| QUOTENAME | | | |
| STR | | | |
| DIFFERENCE | | | |
| REPLACE | | | |
| STUFF | | | |
| LEFT | | | |
| REPLICATE | | | |
| SUBSTRING | | | |
| LEN | | | |
| REVERSE | | | |
| UNICODE | | | |
| LOWER | | | |
| RIGHT | | | |
| UPPER | | | |
| LTRIM | | | |
| RTRIM | | | |
