SQRT
Returns the square root of a non-negative numeric value.
Syntax
SQRT( numeric_value )
Argument | Required/ Optional | Description |
|---|
numeric_value | Required | Positive numeric value. Passes the values for which you want to calculate a square root. You can enter any valid expression. |
Return Value
Double value.
NULL if a value passed to the function is NULL.
Example
The following expression returns the square root for the values in the NUMBERS column:
SQRT( NUMBERS )
NUMBERS | RETURN VALUE |
|---|
100 | 10 |
-100 | None. Informatica Cloud writes the row into the error rows file. |
NULL | NULL |
60.54 | 7.78074546557076 |
The value -100 results in an error during the session, since the function SQRT only evaluates positive numeric values. If you pass a negative value or character value, Informatica Cloud writes the row into the error rows file.
You can perform arithmetic on the values passed to SQRT before the function calculates the square root.