ALLTEXT()

V5

Returns a character string of all of the field values in the current record in the table specified by Table_Alias.

EXTRACT_STRING()

V5

Returns a sub-string from a string, where the sub-string is defined by starting and ending blocks of text.

KEYWORDS()

V5

Returns a sorted list of all of the unique words in Character_Expression. Case-sensitive.

KEYWORDSI()

V5

Returns a sorted list of all of the unique words in Character_Expression. Case-insensitive.

KEYWORDSX()

V5

Returns a sorted list of the Soundex values of all of the unique words in Character_Expression.

LASTWORD()

V5

Returns the last word or entry in a string.

LEADING()

V5

Returns the characters that separate the Word_Number word in Input_String from the previous word.

SUBSTR()

V5

Returns a Substring of a Input_String. The Substring begins at the specified Starting_Position and continues for the specified Number_Of_Characters.

TRAILING()

V5

Returns the characters that separate the Word_Number word in Input_String from the next word.

WORD()

V5

Returns one or more words, specified by the Word_Number and Word_Count and delimited by Word_Delimiter, from the supplied Input_String.

WORD2()

V6

Returns one or more words, specified by the Word_Number and Word_Count and delimited by Word_Delimiter, from the supplied Input_String.

WORD_IN_COMMON()

V5

Returns a list of words in common between List1 and List2.

WORD_UNIQUE()

V5

Returns a list of unique words in a delimited string.