modulo-ssis-expression.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords
(Modulo) (SSIS Expression)	(Modulo) (SSIS Expression)	chugugrace	chugu	03/01/2017	sql	integration-services	conceptual	% (modulo operator) remainder of division operation modulo operator (%)

(Modulo) (SSIS Expression)

[!INCLUDEsqlserver-ssis]

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

Syntax

  
dividend % divisor  
  

Arguments

dividend
Is the numeric expression to divide. dividend can be any valid numeric expression. For more information, see Integration Services Data Types

divisor
Is the numeric expression to divide the dividend by. divisor can be any valid numeric expression except zero.

Result Types

Determined by data types of the two arguments. For more information, see Integration Services Data Types in Expressions.

Remarks

Both expressions must evaluate to signed or unsigned integer data types.

If either operand is null, the result is null.

Modulo zero is not legal.

Expression Examples

This example computes the modulus from two numeric literals. The result is 3.

42 % 13  

This example computes the modulus from the SalesQuota column and a numeric literal.

SalesQuota % 12  

This example computes the modulus from two numeric variables Sales$ and Month. The variable Sales$ must be enclosed in brackets because the name includes the $ character. For more information, see Identifiers (SSIS).

@[Sales$] % @Month  

This example uses the modulo operator to determine if the value of the Value variable is even or odd, and uses the conditional operator to return a string that describes the result. For more information, see ? : (Conditional) (SSIS Expression).

@Value % 2 == 0? "even":"odd"  

See Also

Operator Precedence and Associativity
Operators (SSIS Expression)