image\Dql_0023.giflower

Type

Text Function

Purpose

The lower function converts each letter in a specified text value into lower-case type.

Syntax

lower( TEXT VALUE)

Returns

The specified text value with all the letters in lower case.

Examples

lower( "DataEase" )

Returns: dataease

 

lower( "Club ParaDEASE" )

Returns: club paradease

 

lower( LAST NAME)

Returns: The value in the LAST NAME field in lower-case type for every record that is processed. If a record contains the value Birnbaum in the LAST NAME field, the function returns birnbaum.