SQL character function
character function
A character or string function is a function which takes one or more characters or numbers as parameters and returns a character value. Basic string functions offer a number of capabilities and return a string value as a result set.
SQL character functions are:
| Functions | Description |
|---|---|
| lower() | The SQL LOWER() function is used to convert all characters of a string to lower case. |
| upper() | The SQL UPPER() function is used to convert all characters of a string to uppercase. |
| trim() | The SQL TRIM() removes leading and trailing characters(or both) from a character string. |
| translate() | The SQL TRANSLATE() function replaces a sequence of characters in a string with another sequence of characters. The function replaces a single character at a time. |
Here is a new document which is a collection of questions with short and simple answers, useful for learning SQL as well as for interviews.
Check out our 1000+ SQL Exercises with solution and explanation to improve your skills.
Previous: SQRT
Next: Character Function
LOWER
It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.
https://w3resource.com/sql/character-functions/sql-character-functions.php
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics