The LOWER function returns the text string that it receives as an argument after converting all its letters to their lowercase equivalents.
Syntax
LOWER(
text
)
Parameters
- text: Text string or name of the column containing the texts to be converted to lowercase.
Returned value
The LOWER function returns a text string.
Additional Information
Characters that are not letters are not modified:
In this example you can see how accented vowels are converted, as well as "Ñ" and "Ç". Numbers and special characters are not.
Examples
In the following example we want to use as product code its name converted to lowercase, for which the LOWER function is used:
Related functions
Category
Text