TAIL

Syntax:

TAIL(NCDTY[..] field, N position)

Return Value:

C trailing_charactersNCDTY[..] trailing_values

Description:

TAIL gives the trailing characters of a character field of a specified length. TAIL can also be used to obtain the specified number of occurrences from the end of a multi occurrence field

Example:

TAIL("HELLO",1) = "O"
TAIL(12|23|2|6|70,2) = 6|70