Table of Contents

, , ,

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 ...