Function Methods |
The Function type exposes the following members.
Methods| Name | Description | |
|---|---|---|
  | Abs |
Creates a function that will get the absolute value of the expression
in question
|
| Acos |
Creates a function that will get the inverse cosine of the expression
in question
|
| Asin |
Creates a function that will get the inverse sin of the expression
in question
|
| Atan |
Creates a function that will get the inverse tangent of the expression
in question
|
| Atan2 |
Creates a function that will get the arctangent of the point expressed by
expressions calculating X and Y of the point for the formula
|
| Avg |
Creates a function that will calculate the average of the
expression in question across the results in a particular query
|
| Ceil |
Creates a function that will get the ceiling value of the expression
in question
|
| Contains |
Creates a function that will calculate if a given string is inside of another
in question
|
| Cos |
Creates a function that will get the cosine of the expression
in question
|
| Count |
Creates a function that will count the occurrences of
expression in question across the results in a particular query
|
| Degrees |
Creates a function that will convert a numeric expression to degrees from radians
in question
|
| E |
Creates a function that will return the value of the mathemetical constant 'e'
|
| Exp |
Returns the mathematical constant 'e' raised to the given power
|
| Floor |
Creates a function that will get the floor value of the expression
in question
|
| Length |
Creates a function that gets the length of a string
in question
|
| Ln |
Creates a function that gets the natural log of the numerical expression
|
| Log |
Creates a function that gets the base 10 log of the numerical expression
|
| Lower |
Creates a function that converts a string to lower case
|
| Ltrim |
Creates a function that removes whitespace from the beginning of a string
|
| Max |
Creates a function that will calculate the max value of the
expression in question across the results in a particular query
|
| Min |
Creates a function that will calculate the min value of the
expression in question across the results in a particular query
|
| Pi |
Creates a function that will return the value of the mathemetical constant 'π'
|
| Power |
Creates a function that will raise the given numeric expression
to an expression that determines the exponent
|
| Radians |
Creates a function that will convert a numeric expression to radians from degrees
in question
|
| Round(IExpression) |
Creates a function that will round the given expression
in question
|
| Round(IExpression, IExpression) |
Creates a function that will round the given expression to the number of digits indicated
in question
|
| Rtrim |
Creates a function that removes whitespace from the end of a string
|
| Sign |
Creates a function that returns the sign (positive, negative, or neither) of
the expression in question
|
| Sin |
Creates a function that returns the sin of the expression in question
|
| Sqrt |
Creates a function that returns the square root of the expression in question
|
| Sum |
Creates a function that will calculate the sum of the
expression in question across the results in a particular query
|
| Tan |
Creates a function that returns the tangent of the expression in question
|
| Trim |
Creates a function that removes whitespace from the start and end of a string
|
| Trunc(IExpression) |
Creates a function that will truncate the given expression (i.e remove all the
digits after the decimal place)
in question
|
| Trunc(IExpression, IExpression) |
Creates a function that will truncate the given expression to the number of digits indicated
in question
|
| Upper |
Creates a function that converts a string to upper case
|
See Also