Operators (SQL Server Compact Edition)
Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) supports operators.
Using Operators
SQL Server Compact Edition supports the following operators.
Arithmetic Operators
+ (Add) |
/ (Divide) |
- (Subtract) |
% (Modulo) |
* (Multiply) |
|
Bitwise Operators
& (AND) |
^ (Exclusive OR) |
| (OR) |
~ (NOT) |
Only one expression can be of either binary or varbinary data type in a bitwise operation.
Comparison Operators
= (Equals) |
<> (Not Equal To) |
> (Greater Than) |
!= (Not Equal To) |
< (Less Than) |
!< (Not Less Than) |
>= (Greater Than or Equal To) |
!> (Not Greater Than) |
<= (Less Than or Equal To) |
|
Logical Operators
ALL |
IN |
AND |
LIKE |
ANY |
NOT |
BETWEEN |
OR |
EXISTS |
SOME |
Unary Operators
+ (Positive) |
- (Negative) |