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