APPX Software Library

Chapter 4: SQL Language Elements

4.9.2.77 SQRT function (ODBC compatible)

Syntax

SQRT ( expression )

Description

The scalar function SQRT returns the square root of expression.

Example

SELECT SQRT(28) 'square root of 28'
     FROM SYSTPE.SYSCALCTABLE;

Notes

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