Edit

Share via

&& (Logical AND) (SSIS Expression)

  • Article

Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory

Performs a logical AND operation. The expression evaluates to TRUE if all conditions are TRUE.

Syntax

  
boolean_expression1 && boolean_expression2

Arguments

boolean _expression1, boolean_expression2
Is any valid expression that evaluates to TRUE, FALSE, or NULL.

Result Types

DT_BOOL

Remarks

The following table shows the result of the && operator.

Result Expression Expression
TRUE TRUE TRUE
FALSE TRUE FALSE
FALSE FALSE FALSE
NULL NULL NULL
NULL NULL TRUE
FALSE NULL FALSE

Expression Examples

This example uses the StandardCost and the ListPrice columns. The example evaluates to TRUE if the value of the StandardCost column is less than 300 and the ListPrice column is greater than 500.

StandardCost < 300 && ListPrice > 500

This example uses the variables SPrice and LPrice instead of literals.

StandardCost < @SPrice && ListPrice > @LPrice

See Also

& (Bitwise AND) (SSIS Expression)
Operator Precedence and Associativity
Operators (SSIS Expression)