Index and Filter Functions

AbsReturns the absolute value of the specified numeric expression.
AcosReturns the arc cosine of a specified numeric expression.
AllTrimReturns the specified character expression with leading and trailing blanks removed.
AscReturns the ASCII code for the leftmost character in a character expression.
AsinReturns the arc sine of the specified numeric expression.
AtReturns 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.
AtanReturns the arc tangent of the specified numeric expression.
AtCReturns 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.
Atn2Returns the arc tangent from the specified sine and cosine values.
BetweenDetermines if the value of an expression lies between the values of two other expressions of the same date type.
BofDetermines if the record pointer is positioned at the beginning of a table/.DBF.
CeilingReturns the nearest integer that is greater than or equal to the specified numeric expression.
ChrReturns the character associated with the specified numeric ASCII code.
CosReturns the cosine of an angle.
CTODCharacter to date function, returns a date type value from a character expression.
DateReturns the current system date, which is controlled by the operating system.
DeletedReturns a logical value that indicates whether the current record is marked for deletion.
DescendReturns the complementary value of the expression.
DOWReturns the day of the week from a given date expression.
DTOCReturns a character type date from a date expression.
DTORConverts degrees to radians.
DTOSReturns a character-string date in the format YYYYMMDD from a specified date expression.
EmptyDetermines whether or not an expression is empty.
EofDetermines whether or not the record pointer is positioned past the last record in the current or specified table/.DBF.
FieldnoReturns the field number of a data field.
FloorReturns the nearest integer that is less than or equal to the specified numeric expression.
FvReturns the future value of an investment.
IIFReturns one of two values depending on the value of a logical expression.
InlistDetermines whether or not an expression matches one in a series of expressions of the same data type.
IntEvaluates a numeric expression and returns the integer portion of the expression.
LeftReturns a specified number of characters from a character expression, starting with the leftmost character.
LenReturns the number of characters in a character expression.
LogReturns the natural logarithm (base e) of the specified numeric expression.
Log10Returns the common logarithm (base 10) of the specified numeric expression.
LowerReturns a specified character expression in lower-case letters.
LTrimReturns the specified character expression with leading blanks removed.
MaxReturns the expression with the highest string or numeric value, or latest date, from a list of character, numeric, or date expressions.
MinReturns the expression with the lowest string or numeric value, or latest date, from a list of character, numeric, or date expressions.
ModDivides one numeric expression by another numeric expression and returns the remainder.
PadCReturns the specified expression padded on both left and right sides.
PadLReturns the specified expression padded on the left side.
PadRReturns the specified expression padded on the right side.
PiReturns the numeric constant pi.
ProperReturns the specified character expression with each word having the initial letter capitalized and the remaining characters lowercased.
PvReturns the present value of an investment.
RecNoReturns the current record number in the current or specified table/.DBF.
RightReturns the specified number of rightmost characters from a character string.
RTODConcerts radians to degrees.
RTrimReturns the specified character expression with all trailing blanks removed.
SinReturns the sine of an angle.
SoundexReturns a phonetic representation of the specified character expression.
SpaceReturns a character string composed of a specified number of spaces.
StrReturns the character string equivalent to a specified numeric expression.
StrtranSearches character expressions for occurances of a second character expression, then replaces each occurance with a third character expression.
StrZeroReturns the character string equivalent to a specified numeric expression with leading zeroes replacing spaces.
SubStrReturns a specified number of characters from the given character expression or memo field starting at a specified position.
TanReturns the tangent of an angle.
TrimReturns the specified character expression with all trailing blanks removed.
TypeReturns the data type of the specified memo field or character, numeric, logical or date expression.
UpperReturns the specified character expression in upper-case.
ValReturns a numeric expression from a specified character expression composed of numbers.