logical-or-ssis-expression.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords
|| (Logical OR) (SSIS Expression)	|| (Logical OR) (SSIS Expression)	chugugrace	chugu	03/01/2017	sql	integration-services	conceptual	OR operator logical OR (||) || (logical OR)

|| (Logical OR) (SSIS Expression)

[!INCLUDEsqlserver-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

SSIS Expression 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

| (Bitwise Inclusive OR) (SSIS Expression)
^ (Bitwise Exclusive OR) (SSIS Expression)
Operator Precedence and Associativity
Operators (SSIS Expression)