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

! (Logical Not) (SSIS Expression)

Negates a Boolean operand.

NoteNote

The ! operator cannot be used in conjunction with other operators. For example, you cannot combine the ! and the > operators into the !>. operator.



!boolean_expression
        
boolean_expression

Is any valid expression that evaluates to a Boolean. For more information, see Integration Services Data Types.

The following table shows the result of the ! operation.

Original Boolean expression

After applying the ! operator

TRUE

FALSE

NULL

NULL

FALSE

TRUE

This example evaluates to FALSE if the Color column value is "red".

!(Color == "red")

This example evaluates to TRUE if the value of the MonthNumber variable is the same as the integer that represents the current month. For more information, see MONTH (SSIS Expression) and GETDATE (SSIS Expression).

!(@MonthNumber != MONTH(GETDATE())
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.