SQLJet Home

org.tmatesoft.sqljet.core.schema
Interface ISqlJetBetweenExpression

All Superinterfaces:
ISqlJetExpression

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 Summary
 ISqlJetExpression getExpression()
          Expression.
 ISqlJetExpression getLowerBound()
          Lower bound.
 ISqlJetExpression getUpperBound()
          Upper bound.
 boolean isNot()
          Checks is NOT used.
 
Methods inherited from interface org.tmatesoft.sqljet.core.schema.ISqlJetExpression
getValue
 

Method Detail

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

SQLJet Home

Copyright © 2009-2010 TMate Software Ltd. All Rights Reserved.