# SQRT function

The SQRT function returns the square root of a floating-point number; only the built-in types REAL, FLOAT, and DOUBLE PRECISION are supported.

The return type for SQRT is the type of the parameter.

Note: To execute SQRT on other data types, you must cast them to floating-point types.

## Syntax

    SQRT ( number )

## Examples

    -- throws an exception if any row stores a negative number:
    VALUES SQRT(3421E+09)

    -- returns the square root of an INTEGER after casting it as a
    -- floating-point data type:
    SELECT SQRT(myDoubleColumn) FROM MyTable

    VALUES SQRT (CAST(25 AS FLOAT));

Parent topic: Built-in functions