Skip to content

Latest commit

 

History

History
61 lines (35 loc) · 1.3 KB

numeric-and-comparison-operators.md

File metadata and controls

61 lines (35 loc) · 1.3 KB
Raw
description title ms.date ms.assetid
Learn more about: Numeric and Comparison Operators
Numeric and Comparison Operators
03/30/2017
25b4a26a-06f2-4f80-87a9-76705ed46197

Numeric and Comparison Operators

Arithmetic and comparison operators work as expected in the common language runtime (CLR) except as follows:

  • SQL does not support the modulus operator on floating-point numbers.

  • SQL does not support unchecked arithmetic.

  • Increment and decrement operators cause side-effects when you use them in expressions that cannot be replicated in SQL and are, therefore, not supported.

Supported Operators

[!INCLUDEvbtecdlinq] supports the following operators.

  • Basic arithmetic operators:

    • +

    • - (subtraction)

    • *

    • /

    • Visual Basic integer division (\)

    • % (Visual Basic Mod)

    • <<

    • >>

    • - (unary negation)

  • Basic comparison operators:

    • Visual Basic = and C# ==

    • Visual Basic <> and C# !=

    • Visual Basic Is/IsNot

    • <

    • <=

    • >

    • >=

See also