LEFT
Syntax
LEFT (character_expression, integer)
Description
Returns the specified number of leftmost characters in a character string.
Arguments
| character_expression | An expression of any data type that can be implicitly converted to a string. |
| integer | integer specifies how many characters to return. If integer is negative, TIBCO Cloud™ Integration - Connect returns an error. |
Returns
Returns the specified number of characters in String format.
Examples
LEFT (MyEntity.UserID, 6)
Returns: The first 6 digits of a User ID.
LEFT ("Hadrian Wall", 5)
Returns: "Hadri"