Show TOC

Arithmetic Function (arithmetic_function)Locate this document in the navigation structure

Use

An arithmetic function ( arithmetic_function) is a function that produces a numerical value.

Structure
				
<arithmetic_function>::=
  <ABS>(<expression>)
| <CEIL>(<expression>)
| <EXP>(<expression>)
| <FIXED>(<expression>[,<unsigned_integer>[,<unsigned_integer>]])
| <FLOAT>(<expression>,<unsigned_integer>)
| <FLOOR>(<expression>)
| <INDEX>(<string_spec>,<string_spec>[,<expression>[,<expression>]])
| <LENGTH>(<expression>)
| <LN>(<expression>)
| <LOG>(<expression>)
| <NOROUND>(<expression>)
| <PI>
| <POWER>(<expression>,<expression>)
| <ROUND>(<expression>[,<expression>])
| <SIGN>(<expression>)
| <SQRT>(<expression>)
| <TRUNC>(<expression>[,<expression>])

<string_spec>::=
  <expression>

Explanation

Only expressions that produce an alphanumeric value are permitted as string specification string_spec in the INDEX function.

More Information