Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Microsoft SQL Server Compact 3.5 supports 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)

Show:
© 2015 Microsoft