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)