WebSphere Message Brokers
File: ak05210_
Writer: Bill Oppenheimer

Reference topic

This build: July 31, 2007 21:31:42

LOWER and LCASE functions

The LOWER and LCASE functions are equivalent, and manipulate CHARACTER string data; they both return a new character string, which is identical to source_string, except that all uppercase letters are replaced with the corresponding lowercase letters.

Syntax

For example:
LOWER('Mr Smith') 
returns 'mr smith'.
LOWER('22 Railway Cuttings')
returns '22 railway cuttings'.
LCASE('ABCD')  
returns 'abcd'.
Related concepts
ESQL overview
Related tasks
Developing ESQL
Related reference
Syntax diagrams: available types
ESQL string manipulation functions
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2007Copyright IBM Corporation 1999, 2007. All Rights Reserved.
This build: July 31, 2007 21:31:42

ak05210_ This topic's URL is: