|
<< Click to Display Table of Contents >> Navigation: Available Functions > Lower() |
Syntax
Lower( <FieldName> )
Purpose
To make fields appear as if all their data was entered in lower case.
Parameters
The name of a field or a character expression.
Returns
A Character value.
Usage
This function is the opposite of the "Upper()" function. It is useful when you wish to make all the letters in a field appear in lower case on a report or mailing label.
Example
The following examples demonstrate various results of Lower():
CALL |
RESULT |
|---|---|
Lower( "STRING" ) |
string |
Lower( " 1234 CHARS = " ) |
1234 chars = |
IDLookUp( LinkedDonorFor( "FATHER" ), .First_Name. ) |
Christopher |