sqrt (square root)

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.