Comparison Operators

• Value Comparison Operators – compare values. Values can be numbers, text, strings, column names or expressions. The comparison operators are:

  • Between
  • Not between
  • Exactly
  • Greater than
  • Greater than or equal to
  • Less than
  • Less than or equal to
  • Different from
    

• Pattern comparison operators (case sensitive) – allow text strings to be compared:
  • Begins with
  • Ends with
  • Contains
  • Does not begin with
  • Does not end with
  • Does not contain
  • Like
  • Not like

• Rank operators – used to define Metric qualifications
  • Bottom
  • Equals
  • Exclude Top
  • Exclude Bottom
  • Top

Previous slide

Next slide

Back to first slide

View graphic version