Ø @CHAR(N) -
The character represented by the code N.
Ø @CLEAN(S) -
The string formed by removing all non-printing characters from the string S.
Ø @CODE(S) -
The ASCII code for the first character in string S.
Ø @EXACT(S1, S2) -
Returns true (1) if string S1 exactly matches string S2, otherwise returns 0.
Ø @FIND(S1, S2, N) -
The index of the first occurrence of S1 in S2.
Ø @HEXTONUM(S) -
The numeric value for the hexadecimal interpretation of S.
Ø @LEFT(S, N) -
The string composed of the leftmost N characters of S.
Ø @LENGTH(S) -
The number of characters in S.
Ø @LOWER(S) -
S converted to lower case.
Ø @MID(S, N1, N2) -
The string of length N2 that starts at position N1 in S.
Ø @NUMTOHEX(X) -
The hexadecimal representation of the integer portion of X.
Ø @PROPER(S) -
The string S with the first letter of each word capitalized.
Ø @REGEX(S1, S2) -
Returns true (1) if string S1 exactly matches string S2; otherwise returns false (0). Allows ``wildcard"" comparisons by interpreting S1 as a regular expression.
Ø @REPEAT(S, N) -
The string S repeated N times.
Ø @REPLACE(S1, N1, N2, S2) -
The string formed by replacing the N2 characters starting at position N1 in S1 with string S2.
Ø @RIGHT(S, N) -
The string composed of the rightmost N characters of S.
Ø @STRCAT(...) -
The concatenation of all its arguments.
Ø @STRING(X, N) -
The string representing the numeric value of X, to N decimal places.
Ø @STRLEN(...) -
The total length of all strings in its arguments.
Ø @TRIM(S) -
The string formed by removing spaces from the string S.
Ø @UPPER(S) -
The string S converted to upper case.
Ø @VALUE(S) -
The numeric value represented by the string S; otherwise 0 if S does not represent a number.