CASE()

V5

CASE()returns the value ( Value _1 ... Value _16) specified by the first matching expression whose that evaluates to .T. (TRUE).

CONTAINS()

V5

Returns .T. (TRUE) if all words in the Find_Words string appear at least once in the Search_String. Case sensitive.

CONTAINSI()

V5

Returns .T. (TRUE) if all words in the Find_Words string appear at least once in the Search_String. Case insensitive.

CONTAINSX()

V5

Returns TRUE if all words in the Find_Words appear at least once in the Search_String. Searches are based on Soundex values.

SOUNDEX()

V5

Returns a 4-character code in a string that represents the phonetic equivalent of the supplied Input_String.

DIFFERENCE()

V5

Returns an Integer ranging from 0 to 4, which represents the difference between the Soundex values for CharacterString1 and CharacterString2.

LEN()

V5

Returns an integer equal to the number of characters in the Input_String.

LIKE()

V5

Returns .T. (TRUE) if Find_String, which can use wildcard characters, equals Search_In_String.

MAX_STR_LENGTH()

V5

Returns the length of the longest sub string in the string.

SMATCH()

V5

Returns .T. (TRUE) if Input_String matches Match_To_String.

SMATCH_MEMO()

V5

Searches within the text of a Memo field and returns .T. (TRUE) if Character_Pattern is found in the field Memo_Field_Name.

SMATCH_TO()

V5

Returns everything to the left of and including the matched portion of a string.

StrEqual()

V8

Compares two character strings, with options to ignore white space and character differences.