Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference LOWERCASE
Functions and Expressions Reference Guide
148
LOWERCASE
The LOWERCASE function converts a text item to all lowercase characters.
Syntax
LOWERCASE (single-text-expression)
Meaning
LOWERCASE (text_to_convert)
Returns
This function returns a single-text-item.
Produces a text item in which each byte from the input has been converted to
lowercase. Any numeric or symbol characters in the text item remain
unchanged.
Example
LOWERCASE ("A1b2C!") returns a1b2c!
Uses
Use
LOWERCASE to convert an alphabetic text item to all lowercase characters.
Related Functions
ISLOWER, ISUPPER, UPPERCASE