sqrt

Type
Scientific Function

Purpose
The sqrt function calculates the square root of a numeric value.

Syntax
sqrt( NUMERIC VALUE)

Returns
A numeric value.

Usage
The numeric value in a Scientific function can be a constant value, a variable, a field value, or an expression. The sqrt function should only be used on a positive value. If the input value is negative, the result is unpredictable.

Examples
sqrt( 9)
Returns: 3

sqrt( 16)
Returns: 4

sqrt( FLOOR SPACE)
Returns: The square root of the value in the FLOOR SPACE field for every record processed. If a record contains the value 16000 in the FLOOR SPACE field, the function returns 40.