This topic has not yet been rated - Rate this topic

! (Logical Not) (SSIS)

SQL Server 2005

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

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

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())

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD

! (Logical Not) (SSIS)

Concepts

Other Resources

Help and Information

Community Additions