Set of values: Maximum Selects the maximum value of a set of values Time: Hour Returns the hour based on the hour field in time expression as an integer value in the range of 0-23 Angle: Degrees Converts radians into degrees String1: String2: Concat Concatenates two character strings Angle: Tangent Returns the tangent of an angle Date part: StartDate: EndDate: DateDiff Returns the number of date and time boundaries crossed between two specified dates. StartDate is subtracted from EndDate. If StartDate is later than EndDate, a negative value is returned Angle: Sine Returns the sine of an angle Character string: Lowercase Returns a character string in lower case Time: Minute Returns the minute based on the minute field in time expression as an integer value in the range of 0-59 Date: DayOfYear Returns the day of the year (1-366) Expression1: Expression2: Expression3: Replace Replaces all occurrences of Expression2 with Expression3 in Expression1 Set of values: Sum Returns the sum of the values of a column Case expression: Case expression: Result: Result: Case Returns a value that depends on which of the specified conditions is met Date: DayName Returns a character string containing the data source-specific name of the day of the specified date CurrentTimestamp Returns the current timestamp Interval: Date: Returns a new date time value based on adding an interval to the specified date. The returned date-time data type is the same as the input date data type Date: MonthName Returns a character string containing the data source-specific name of the month of the specified date ASCII code: Character Returns the character that corresponds to the ASCII code Time: Second Returns the second based on the second field in time expression as an integer value in the range of 0-59 Question: Numeric Prompt Prompts the user to enter a specific value Numerical expression: Log10 Returns the base 10 logarithm of the specified value Value: ArcSine Returns the arc sine of a numerical expression Numerical expression: Radians Converts degrees into radians Numerical expression: StandardDeviation Returns the standard deviation of a numerical expression Date: Number of the week Returns the number of the week (1-52) Numerical expression: Power: Power Returns a value raised to the nth power Value: HyperbolicCosine Returns the hyperbolic cosine of a number in radians Numerical expression: Number of decimal places: Round Returns a number rounded to n decimal places Character string: Number of characters to extract: Leftpart Returns the specified number of characters from the left of a character string Date: DayOfMonth Returns the day of the month (1-31) First argument: Second argument: If Null Returns the first argument if it is not null, the second otherwise Angle1: Angle2: AngleTangent2 Returns the angle in radians whose tangent is Angle1/Angle2 Character: ASCII Code Returns the ASCII code of a character Pi Returns the constant value of 3.1415926535897932 Date: Format: DateFormat Returns a date-time value as a character string literal in the DEFAULT, USA or EUROPEAN format Set of values: Minimum Selects the minimum value of a set fo values Value: HyperbolicSine Returns the hyperbolic sine of a number in radians Date: Number of the month Returns the number of the month (1-12) Date: Year Returns the year Character string: Search: Locate Returns the position of a character in a character string Value: ArcCosine Returns the arc cosine of a numerical expression Value: HyperbolicTangent Returns the hyperbolic tangent of a number in radians Value: ArcTangent Returns the arc tangent of a numerical expression Value: Divided by: Mod Returns the remainder of a division Value: Exp Returns the exponential value of the specified value Date: Day Returns the day of the month Character string: LeftRemove Removes blank characters from the left of a character string Numerical expression: Floor Returns the value of a number rounded down to the nearest integer Date: Quarter Returns the quarter Set of values: Average Returns the average value of a set of values Character string: RightRemove Removes blank characters from the right of a character string Question: Character Prompt Prompts the user to enter a specific value Expression: IsNull Returns TRUE if the expression is NULL Numerical expression: Variance Returns the variance of a numerical expression Numerical expression: Ceil Returns the value of a number rounded up to the nearest integer Numerical expression: Absolute Returns the absolute value of a given expression Character string: Number of characters to extract: Rightpart Returns the specified number of characters from the right of a character string Character string: Initial position: Number of characters: Substring Extracts a sequence of characters from a character string Character string: Uppercase Returns a character string in upper case Value: Log Returns the natural logarithm of the specified value Date: Month Returns the number of the month CurrentDate Returns the current date Question: Date Prompt Prompts the user to enter a specific value CurrentTime Returns the current time Character string: Length Returns the length of a character string Number: Sqrt Returns the square root of a number Expression: Count Counts the number of values in a set of values Date: DayOfWeek Returns the day of the week (1 equals Sunday) Angle: Cosine Returns the cosine of an angle Value: Sign Returns a number that represents the sign of the specified number