w3resource

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



Become a Patron!

Follow us on Facebook and Twitter for latest update.

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://www.w3resource.com/sql/character-functions/sql-character-functions.php