RIGHT
Syntax
RIGHT (character_expression, integer)
Description
Returns the specified number of rightmost 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.
Example
If MyEntity.ZipLong is the 9 digit Zip+4 Zip Code:
RIGHT (MyEntity.ZipLong, 4)
Returns: The last four digits of the Zip+4 Zip Code.