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.

Syntax: How to Return a String With All Letters Lowercase

LOWER(string)

where:

string

Alphanumeric

Is the string to convert to lowercase.

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

LOWER converts LAST_NAME to lowercase.

LOWER(LAST_NAME)

For STEVENS, the result is stevens.

	WebFOCUS