Export (0) Print
Expand All
Expand Minimize

ATCC( ) Function

Returns the beginning numeric position of the first occurrence of a character expression or memo field within another character expression or memo field, without regard for the case of these two expressions.


ATCC(cSearchExpression, cExpressionSearched [, nOccurrence])

Parameters

cSearchExpression

Specifies the character expression that ATCC( ) 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, ATCC( ) searches for the first occurrence of cSearchExpression (nOccurrence = 1). Including nOccurrence lets you search for additional occurrences of cSearchExpression in cExpressionSearched.

Numeric

ATCC( ) is designed for expressions containing double-byte characters. If the expression contains only single-byte characters, ATCC( ) is equivalent to ATC( ).

ATCC( ) searches the second character expression for the occurrence of the first character expression, without concern for the case (upper or lower) of the characters in either expression. Use AT_C( ) to perform a case-sensitive search.

ATCC( ) returns an integer corresponding to the position where the first character of the character expression is found. If the character expression isn't found, ATCC( ) returns 0.

This function is useful for manipulating double-byte character sets for languages such as Hiragana and Katakana.

Community Additions

ADD
Show:
© 2014 Microsoft