# SQRT

## Synopsis

SQRT(numeric-expression) {fn SQRT(numeric-expression)}

### Arguments

Argument | Description |
---|---|

numeric-expression | An expression that resolves to a positive number from which the square root is calculated. |

## Description

SQRT returns the square root of numeric-expression. The numeric-expression must be a positive number. A negative numeric-expression (other than -0) generates an SQLCODE -400 error. SQRT returns NULL if passed a NULL value.

SQRT returns a value of data type NUMERIC, unless numeric-expression is data type DOUBLE, in which case the returned data type is DOUBLE. The returned value has a precision of 36 and a scale of 18.

SQRT can be specified as a regular scalar function or as an ODBC scalar function (with the curly brace syntax).

## Examples

The following example shows the two SQRT syntax forms. Both return the square root of 49:

SELECT SQRT(49) AS SRoot,{fn SQRT(49)} AS ODBCSRoot

The following embedded SQL example returns the square roots of the integers 0 through 10:

SET a=0 WHILE a<11 { &sql(SELECT SQRT(:a) INTO :b) IF SQLCODE'=0 { WRITE !,"Error code ",SQLCODE QUIT } ELSE { WRITE !,"The square root of ",a," = ",b SET a=a+1 } }