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