WORDS_FROM_RIGHT
Description
Returns the text being the specified number of the rightmost words in the provided text.
note
Cloudscape/Derby database only.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
Example
IF WORDS_FROM_RIGHT (Account.Name, 1) = 'Smith' THEN ...