LOWER( )
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.