Export (0) Print
Expand All
Expand Minimize

Operators (SQL Server Compact Edition)

Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) supports 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)

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft