LOWER

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:

LOWER function: Example of use

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:

LOWER function: Example of use

Related functions
Category
Text
Submitted by admin on Mon, 12/03/2018 - 23:51