parentheses-ssis-expression.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords
() (Parentheses) (SSIS Expression)	() (Parentheses) (SSIS Expression)	chugugrace	chugu	03/01/2017	sql	integration-services	conceptual	() (parentheses operator) evaluation order [Integration Services] parentheses operator ()

() (Parentheses) (SSIS Expression)

[!INCLUDEsqlserver-ssis]

Identifies the evaluation order of expressions. Expressions enclosed in parentheses have the highest evaluation precedence. Nested expressions enclosed in parentheses are evaluated in inner-to-outer order.

Parentheses are also used to make complex expressions easier to understand.

Syntax

  
(expression)  
  

Arguments

expression
Is any valid expression.

Result Types

The data type of expression. For more information, see Integration Services Data Types.

Expression Examples

This example shows how the use of parenthesis modifies the precedence of operators. The first expression evaluates to 100, whereas the second one evaluates to 31.

(5 + 5) * (4 + 6)  
5 + 5 * 4 + 6  
  

See Also

Operator Precedence and Associativity
Operators (SSIS Expression)