Table of Contents

Search

  1. Preface
  2. The Transformation Language
  3. Constants
  4. Operators
  5. Variables
  6. Dates
  7. Functions
  8. Creating Custom Functions
  9. Custom Function API Reference

Transformation Language Reference

Transformation Language Reference

LOWER

LOWER

Converts uppercase string characters to lowercase.

Syntax

LOWER(
string
)
The following table describes the argument for this command:
Argument
Required/
Optional
Description
string
Required
Any string value. The argument passes the string values that you want to return as lowercase. You can enter any valid transformation expression that evaluates to a string.

Return Value

Lowercase character string. If the data contains multibyte characters, the return value depends on the code page and data movement mode of the Integration Service.
NULL if a value in the selected port is NULL.

Example

The following expression returns all first names to lowercase:
LOWER( FIRST_NAME )
FIRST_NAME
RETURN VALUE
antonia
antonia
NULL
NULL
THOMAS
thomas
PierRe
pierre
BERNICE
bernice