This topic has not yet been rated - Rate this topic

|| (Logical OR) (SSIS)

SQL Server 2005

SQL Server 2012

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


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

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD

|| (Logical OR) (SSIS)

Reference

Concepts

Other Resources

Help and Information

Community Additions