SQL Reference Guide

SQRT function (ODBC compatible)

Syntax

SQRT ( expression )

Description

The scalar function SQRT returns the square root of the expression.

Example

SELECT SQRT(28) 'square root of 28'

FROM ADMIN.SYSCALCTABLE;

Notes

• The value of the expression must be positive.
• The expression must evaluate to an approximate numeric data type.