WebSphere Message Brokers
File: ak05200_
Writer: Bill Oppenheimer

Reference topic

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

LENGTH function

The LENGTH function is used for string manipulation on all string data types (BIT, BLOB, and CHARACTER) and returns an integer value giving the number of singletons in source_string.

Syntax

It If the source_string is NULL, the result is the NULL value. The term singleton refers to a single part (BIT, BYTE, or CHARACTER) within a string of that type.

For example:
LENGTH('Hello World!');
returns 12.
LENGTH('');
returns 0.
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:41

ak05200_ This topic's URL is: