Built-In Functions and Syntax › Square Root

Square Root

The square-root function returns the square root of a numeric value.

Syntax:

►►─┬─ SQRT ────────┬─ (value) ────────────────────────────────────────────────►◄
   ├─ @SQRT ───────┤
   └─ SQUARE-ROOT ─┘

Invocation names:

SQRT
@SQRT
SQUARE-ROOT

Parameters:

(value)

Specifies the numeric value whose square root is calculated. Value cannot be a negative number.

Example:

This example calculates the square root of OPER1. The initial value of OPER1 is 256.

select sqrt(oper1) as 'square root' from table1

  SQUARE ROOT = 16