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