WORDS_FROM_RIGHT
Description
Returns the text being the specified number of the rightmost words in the provided text.
note
Cloudscape/Derby database only.
Syntax
WORDS_FROM_RIGHT (text, count)
Cannot be used in the condition of a FIND action.
Parameters
Attribute of the Plain Text type or string constant or calculation producing text and an integer constant indicating the number of words to retrieve
Returns
Text: the given number of rightmost words of the text (Cloudscape/Derby database only).
Example
IF WORDS_FROM_RIGHT (Account.Name, 1) = 'Smith' THEN ...