Interface ISqlJetBetweenExpression

All Superinterfaces:
ISqlJetExpression
All Known Implementing Classes:
SqlJetBetweenExpression

public interface ISqlJetBetweenExpression extends ISqlJetExpression

The BETWEEN operator.

The BETWEEN operator is equivalent to a pair of comparisons. "a BETWEEN b AND c" is equivalent to "a>=b AND a<=c". The precedence of the BETWEEN operator is the same as the precedence as operators == and != and LIKE and groups left to right.

Format:

<expression> [NOT] BETWEEN <lowerBound> AND <upperBound>

Author:
TMate Software Ltd., Dmitry Stadnik (dtrace@seznam.cz)
  • Method Details

    • getExpression

      ISqlJetExpression getExpression()
      Expression.
      Returns:
      expression
    • isNot

      boolean isNot()
      Checks is NOT used.
      Returns:
      true if NOT is used
    • getLowerBound

      ISqlJetExpression getLowerBound()
      Lower bound.
      Returns:
      lower bound
    • getUpperBound

      ISqlJetExpression getUpperBound()
      Upper bound.
      Returns:
      upper bound