Share via


Operators (SSIS Expressions)

This section describes the operators the expression language provides and the operator precedence and associativity that the expression evaluator uses.

The following table lists topics about operators in this section.

Operator

Description

Cast (SSIS Expressions)

Converts an expression from one data type to a different data type.

() (Parentheses) (SSIS Expressions)

Identifies the evaluation order of expressions.

+ (Add) (SSIS Expressions)

Adds two numeric expressions.

+ (Concatenate) (SSIS Expressions)

Concatenates two expressions.

- (Subtract) (SSIS Expressions)

Subtracts the second numeric expression from the first one.

- (Negate) (SSIS Expressions)

Negates a numeric expression.

* (Multiply) (SSIS Expressions)

Multiplies two numeric expressions.

/ (Divide) (SSIS Expressions)

Divides the first numeric expression by the second one.

% (Modulo) (SSIS Expressions)

Provides the integer remainder after dividing the first numeric expression by the second one.

|| (Logical OR) (SSIS Expressions)

Performs a logical OR operation.

&& (Logical AND) (SSIS Expressions)

Performs a logical AND operation.

! (Logical Not) (SSIS Expressions)

Negates a Boolean operand.

| (Bitwise Inclusive OR) (SSIS Expressions)

Performs a bitwise OR operation of two integer values.

^ (Bitwise Exclusive OR) (SSIS Expressions)

Performs a bitwise exclusive OR operation of two integer values.

& (Bitwise AND) (SSIS Expressions)

Performs a bitwise AND operation of two integer values.

~ (Bitwise Not) (SSIS Expressions)

Performs a bitwise negation of an integer.

== (Equal) (SSIS Expressions)

Performs a comparison to determine if two expressions are equal.

!= (Unequal) (SSIS Expressions)

Performs a comparison to determine if two expressions are not equal.

> (Greater Than) (SSIS Expressions)

Performs a comparison to determine if the first expression is greater than the second one.

< (Less Than) (SSIS Expressions)

Performs a comparison to determine if the first expression is less than the second one.

>= (Greater Than or Equal To) (SSIS Expressions)

Performs a comparison to determine if the first expression is greater than or equal to the second one.

<= (Less Than or Equal To) (SSIS Expressions)

Performs a comparison to determine if the first expression is less than or equal to the second one.

? : (Conditional) (SSIS Expressions)

Returns one of two expressions based on the evaluation of a Boolean expression.

For information about the placement of each operator in the precedence hierarchy, see Operator Precedence and Associativity.