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. SQRT function

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

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));