Operators

Last updated: 2019-10-25 16:04:52

    COS Select supports the following operators:

    Operator Type Operator
    Logical operator AND, NOT, OR
    Comparison operator <, >, <= ,>= , = , <>, !=, BETWEEN, IN, such as IN ('a', 'b', 'c')
    Pattern matching operator LIKE
    Mathematical operator +, -, *, %

    Priority of Operators

    The following table shows the priority of operators in descending order:

    Operator/Element Association Use Case
    - Right Unary subtraction
    *, /, % Left Multiplication, division, and modulo
    +, - Left Addition and subtraction
    IN - Setting membership
    BETWEEN - In the range of ()
    LIKE - String pattern matching
    <> - Less than and greater than
    = Right Equivalence and assignment
    NOT Right Logical NOT
    AND Left Logical AND
    OR Left Logical OR

    Was this page helpful?

    Was this page helpful?

    • Not at all
    • Not very helpful
    • Somewhat helpful
    • Very helpful
    • Extremely helpful
    Send Feedback
    Help