SQL character function

Last update on August 19 2022 21:51:36 (UTC/GMT +8 hours)

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