LOWER: Returning a String With All Letters Lowercase

How to:

The LOWER function takes a source string and returns a string of the same data type with all letters translated to lowercase.


Top of page

x
Syntax: How to Return a String With All Letters Lowercase
LOWER(source_string)

where:

source_string

Alphanumeric

Is the string to convert to lowercase.

The returned string is the same data type and length as the source string.



Example: Converting a String to Lowercase

LOWER converts LAST_NAME to lowercase.

LOWER(LAST_NAME)

For STEVENS, the result is stevens.


iWay Software