! (Logical Not) (SSIS)

Negates a Boolean operand.

Note

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

Syntax


!boolean_expression
        

Arguments

Result Types

DT_BOOL

Remarks

The following table shows the result of the ! operation.

Original Boolean expression After applying the ! operator

TRUE

FALSE

NULL

NULL

FALSE

TRUE

Examples

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) and GETDATE (SSIS).

!(@MonthNumber != MONTH(GETDATE())

See Also

Concepts

Operator Precedence and Associativity

Other Resources

Operators (SSIS)

Help and Information

Getting SQL Server 2005 Assistance