WebSphere Message Brokers
File: ak05220_
Writer: Bill Oppenheimer

Reference topic

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

LTRIM function

LTRIM is a string manipulation function, used for manipulating all data types (BIT, BLOB, and CHARACTER), that returns a character string value of the same data type and content as source_string, but with any leading default singletons removed.

Syntax

The term singleton is used to refer to a single part (BIT, BLOB, or CHARACTER) within a string of that type.

The LTRIM function is equivalent to TRIM(LEADING FROM source_string).

If the parameter is NULL, the result is NULL.

The default singleton depends on the data type of source_string:
Table 1.
Character ' ' (space)
BLOB X'00'
Bit B'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:42

ak05220_ This topic's URL is: