# SQUARE (SSIS Expressions)

Returns the square of a numeric expression.

This example returns the square of 12. The return result is 144.

SQUARE(12)

This example returns the square of the result of subtracting values in two columns. If **Value1** contains 12 and **Value2** contains 4, the SQUARE function returns 64.

SQUARE(Value1 - Value2)

This example returns the length of the third side of a right angle triangle by applying the SQUARE function to two variables and then calculating the square root of their sum. If **Side1** contains 3 and **Side2** contains 4, the SQRT function returns 5.

SQRT(SQUARE(@Side1) + SQUARE(@Side2))

Note |
---|

In expressions, variable names always include the @ prefix. |

## Community Additions

ADD
Show: