title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | |||
---|---|---|---|---|---|---|---|---|---|---|---|
&& (Logical AND) (SSIS Expression) |
&& (Logical AND) (SSIS Expression) |
chugugrace |
chugu |
03/01/2017 |
sql |
integration-services |
conceptual |
|
[!INCLUDEsqlserver-ssis]
Performs a logical AND operation. The expression evaluates to TRUE if all conditions are TRUE.
boolean_expression1 && boolean_expression2
boolean _expression1, boolean_expression2
Is any valid expression that evaluates to TRUE, FALSE, or NULL.
DT_BOOL
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 |
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
& (Bitwise AND) (SSIS Expression)
Operator Precedence and Associativity
Operators (SSIS Expression)