These scalar functions perform an operation on a string input value and return a string or numeric value.
| ASCII | REPLICATE |
| CHAR | REVERSE |
| CHARINDEX | RIGHT |
| DIFFERENCE | RTRIM |
| LEFT | SOUNDEX |
| LEN | SPACE |
| LOWER | STR |
| LTRIM | STUFF |
| NCHAR | SUBSTRING |
| PATINDEX | UNICODE |
| REPLACE | UPPER |
| QUOTENAME |