Returns the beginning numeric position of the first occurrence of a character expression or memo field within another character expression or memo field, counting from the leftmost character.

AT_C(cSearchExpression, cExpressionSearched [, nOccurrence])

Parameters

cSearchExpression

Specifies the character expression that AT_C( ) searches for in cExpressionSearched.

cExpressionSearched

Specifies the character expression cSearchExpression searches for.

Both cSearchExpression and cExpressionSearched can be memo fields of any size.

nOccurrence

Specifies which occurrence (first, second, third, and so on) of cSearchExpression is searched for in cExpressionSearched. By default, AT_C( ) searches for the first occurrence of cSearchExpression (nOccurrence = 1). Including nOccurrence lets you search for additional occurrences of cSearchExpression in cExpressionSearched. AT_C( ) returns 0 if nOccurrence is greater than the number of times cSearchExpression occurs in cExpressionSearched.

Return Value

Remarks

See Also

Reference

$ Operator
ATCC( ) Function
AT( ) Function
ATC( ) Function
ATCLINE( ) Function
ATLINE( ) Function
INLIST( ) Function
LEFT( ) Function
LEFTC( ) Function
OCCURS( ) Function
RAT( ) Function
RATC( ) Function
RATLINE( ) Function
RIGHT( ) Function
RIGHTC( ) Function
SUBSTR( ) Function
SUBSTRC( ) Function

Other Resources

Functions
Language Reference (Visual FoxPro)