Returns the numeric position of the last (rightmost) occurrence of a character string within another character string.

RAT(cSearchExpression, cExpressionSearched [, nOccurrence])

Parameters

cSearchExpression

Specifies the character expression that RAT( ) looks for in cExpressionSearched. The character expression can refer to a memo field of any size.

cExpressionSearched

Specifies the character expression that RAT( ) searches. The character expression can refer to a memo field of any size.

nOccurrence

Specifies which occurrence, starting from the right and moving left, of cSearchExpression RAT( ) searches for in cExpressionSearched. By default, RAT( ) searches for the last occurrence of cSearchExpression (nOccurrence = 1). If nOccurrence is 2, RAT( ) searches for the next to last occurrence, and so on.

Return Value

Remarks

Example

	Copy Code
STORE 'abracadabra' TO string STORE 'a' TO find_str CLEAR ? RAT(find_str,string) && Displays 11 ? RAT(find_str,string,3) && Displays 6

See Also