TechNet
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize
The document is archived and information here might be outdated

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)

Show:
© 2016 Microsoft