Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

|| (Logical OR) (SSIS Expressions)

Performs a logical OR operation. The expression evaluates to TRUE if one or both conditions are TRUE.

boolean_expression1 || boolean_expression2
boolean_expression1, boolean_expression2

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

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

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
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.