IBM App Connect Enterprise, Version 11.0.0.2 Operating Systems: Windows, Linux


LEFT function

LEFT is a string manipulation function that returns a string consisting of the source string truncated to the LEFT given by the length expression.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-LEFT--(--source_string--,--LengthIntegerExpression--)-------><

The source string can be of the CHARACTER, BLOB or BIT data type and the length must be of type INTEGER. The truncation discards the final characters of the source_string

The result is of the same type as the source string. If the length is negative or zero, a zero length string is returned. If either parameter is NULL, the result is NULL


ak05191_.htm | Last updated 2018-11-02 14:45:54