Function Name
|
Type
|
Description
|
Abs()
|
Numeric
|
Calculates the absolute value of a number
|
Acos()
|
Numeric
|
Calculates the arc cosine of a number
|
Asin()
|
Numeric
|
Calculates the arc sine of a number
|
Atan()
|
Numeric
|
Calculates the arc tangent of a number
|
Avg()
|
List
|
Calculates the average of a list
|
Ceiling()
|
Numeric
|
Calculates the smallest number greater than or equal to an input number
|
Chr()
|
Text
|
Converts numeric ASCII character codes to alphabetic and special characters
|
Contains()
|
Text
|
Determines if a search string is included in an input string
|
Cos()
|
Numeric
|
Calculates the cosine of a number
|
Curdate()
|
Date/Time
|
Returns the current system date
|
Date()
|
Conversion
|
Converts a character string to a date
|
Day()
|
Date/Time
|
Returns a day from an input date
|
Dayname()
|
Date/Time
|
Returns the name of the day of the week from an input date
|
Dayofweek()
|
Date/Time
|
Returns the number of the day of the week from an input date
|
Empty()
|
Other
|
Determines if a field has a null or empty value
|
Exp()
|
Numeric
|
Calculates the constant E raised to a power of a number
|
Floor()
|
Numeric
|
Calculates the largest number less than or equal to an input number
|
Hour()
|
Date/Time
|
Returns an hour from an input date
|
Iif()
|
Other
|
Returns one of two values based on a Boolean statement
|
Instr()
|
Text
|
Returns the position of a search string in an input string, starting from the left
|
Isnull()
|
Other
|
Determines if a field has a null value
|
Left()
|
Text
|
Returns the leftmost characters in a string
|
Length()
|
Text
|
Returns the number of characters in a string
|
Lfind()
|
Text
|
Returns the position of a search string in an input string, starting from the left
|
Ln()
|
Number
|
Calculates the natural log of a number
|
Log()
|
Numeric
|
Calculates the logarithm of a number in a specified base
|
Lower()
|
Text
|
Converts all characters in a string to lowercase
|
Lpad()
|
Text
|
Adds characters or spaces to the left side of a character string
|
Ltrim()
|
Text
|
Removes characters or spaces from the left side of a character string
|
Max()
|
List
|
Calculates the maximum value from a list
|
Min()
|
List
|
Calculates the minimum value from a list
|
Minute()
|
Date/Time
|
Returns a minute from an input date
|
Mod()
|
Numeric
|
Calculates the remainder of the numerator divided by the denominator
|
Month()
|
Date/Time
|
Returns a month from an input date
|
Monthname()
|
Date/Time
|
Returns the month name from an input date
|
Pi()
|
Numeric
|
Returns an approximation of the number Pi
|
Power()
|
Numeric
|
Calculates the base raised to a power of a number
|
Proper()
|
Text
|
Converts the first character each part of a string to uppercase and all other characters to lowercase
|
Rand()
|
Numeric
|
Calculates a random number between zero and one
|
Recid()
|
Other
|
Returns a string that uniquely identifies a record
|
Recno()
|
Other
|
Returns a number indicating the absolute position of a record in a data set
|
Regexp()
|
Text
|
Returns a portion of a string that matches the regular expression given by the match string
|
Repeat()
|
Text
|
Repeats the characters in a string for a specified length
|
Replace()
|
Text
|
Replaces each occurrence of a search string in an input string with another string
|
Reverse()
|
Text
|
Reverses the order of characters in a string
|
Rfind()
|
Text
|
Returns the position of a search string in an input string, starting from the right
|
Right()
|
Text
|
Returns the rightmost characters in a string
|
Round()
|
Numeric
|
Rounds a number to a specified precision
|
Rpad()
|
Text
|
Adds characters or spaces to the right side of a character string
|
Rtrim()
|
Text
|
Removes characters or spaces from the right side of a string
|
Second()
|
Date/Time
|
Returns a second from an input date
|
Sign()
|
Numeric
|
Returns the sign of a number
|
Sin()
|
Numeric
|
Returns the sine of a number
|
Soundex()
|
Text
|
Returns a phonetic representation of a string
|
Stddev()
|
List
|
Calculates the standard deviation of a list
|
Str()
|
Conversion
|
Converts a date or numeric value to a character string
|
Strpart()
|
Text
|
Returns the nth section of an input string
|
Substr()
|
Text
|
Returns a portion of an input string
|
Sum()
|
List
|
Calculates the sum of a list
|
Tan()
|
Numeric
|
Calculates the tangent of a number
|
Translate()
|
Text
|
Replaces each character in a string with a corresponding character in a search list with a character from a replace list
|
Trim()
|
Text
|
Removes characters from the left and right sides of an input string
|
Trunc()
|
Numeric
|
Truncates a number to a specified precision
|
Upper()
|
Text
|
Converts all characters in a string to uppercase
|
Val()
|
Conversion
|
Converts a character string to a numeric value
|
Variance()
|
List
|
Calculates the variance of a list
|
Week()
|
Date/Time
|
Returns a week from an input date
|
Year()
|
Date/Time
|
Returns a year from an input date
|
