WORDS_FROM_RIGHT

Returns the text being the specified number of the rightmost words in the provided text. <callout type=“primary” title=“note” icon=“true”>Cloudscape/Derby database only.</callout>

Attribute of the Plain Text type or string constant or calculation producing text and an integer constant indicating the number of words to retrieve

IF WORDS_FROM_RIGHT (Account.Name, 1) = 'Smith' THEN ...