Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Microsoft SQL Server Compact 3.5 (SQL Server Compact 3.5) supports operators.
Using Operators
SQL Server Compact 3.5 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) |