|| (Logical OR) (SSIS)
Performs a logical OR operation. The expression evaluates to TRUE if one or both 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 |
TRUE |
TRUE |
FALSE |
FALSE |
FALSE |
FALSE |
NULL |
NULL |
NULL |
TRUE |
NULL |
TRUE |
NULL |
NULL |
FALSE |
Examples
This example uses the StandardCost and ListPrice columns. The example evaluates to TRUE if the value of the StandardCost column is less than 300 or the ListPrice column is greater than 500.
StandardCost < 300 || ListPrice > 500
This example uses the variables SPrice and LPrice instead of numeric literals.
StandardCost < @SPrice || ListPrice > @LPrice
See Also
Reference
| (Bitwise Inclusive OR) (SSIS)
^ (Bitwise Exclusive OR) (SSIS)
Concepts
Operator Precedence and Associativity