This section provides you with some handy SQL string functions that allow you to manipulate string data more effectively.
| Name | Description |
|---|---|
| ASCII | Returns ASCII code of the first character of a string |
| CHR | Returns the character corresponding to the input ASCII code |
| CONCAT | Returns the result of the concatenation of two or more strings |
| LOWER | Converts all characters in a string to lowercase |
| LENGTH | Returns the number of characters in a given string. Some database systems use the LEN function instead. |
| SUBSTRING | Extracts a substring from a string |
| REPLACE | Replaces all occurrences of a specified substring in a string by a new substring |
| TRIM | Removes unwanted characters e.g., whitespaces from a string |
| UPPER | Converts all characters in a string to uppercase |
