Table of Contents

, , ,

WORDS_FROM_LEFT

Description

Returns the text being the specified number of the leftmost 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_LEFT (Account.Name, 1) = 'John' THEN ...