Converts all uppercase characters in a string to lowercase and returns the resulting string.

Syntax

LOWER(<expC>)

<expC>

The string you want to convert to lowercase.

Description

LOWER( ) converts the uppercase alphabetic characters in a character expression or memo field to lowercase. LOWER( ) ignores digits and other characters.

The current language driver defines the character values that are lowercase and uppercase alphabetic. In a U.S. language driver, a lowercase alphabetic character is from a to z, and an uppercase alphabetic character is from A to Z.

Other than the syntactic difference of being a method instead of a function, the toLowerCase( ) method behaves identically to the LOWER( ) function.