Returns the square root of expression.

Syntax

SQRT ( expression )

Notes

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

Example

This example illustrates the SQRT function, requesting the square root of the value ‘28':

SELECT SQRT(28) 'square root of 28' FROM MYMATH;

Compatibility

ODBC compatible