~ (Bitwise Not) (SSIS Expression)
Applies to: 
SQL Server
SSIS Integration Runtime in Azure Data Factory
Performs a bitwise negation of an integer. This operator can be applied to signed and unsigned integer data types.
Syntax
~integer_expression
Arguments
integer_expression
Is any valid expression of an integer data type. integer_expression is an integer that is transformed into a binary number for the bitwise operation. For more information, see Integration Services Data Types.
Result Types
Returns the data type of integer_expression.
Remarks
None
Expression Examples
This example performs a bitwise ~ (NOT) operation on the number 170 (0000 0000 1010 1010). The number is a signed integer.
~ 170
The expression evaluates to -170 (1111111101010101).
0000000010101010
----------------------
1111111101010101
See Also
Operator Precedence and Associativity
Operators (SSIS Expression)
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for