Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

between or between

SQL Syntax

between or between

by  danceman  Posted    (Edited  )
BETWEEN
Determines whether the value of an expression lies between the values of two other expressions of the same data type.

There are two types of BETWEEN

1.FoxPro
BETWEEN(eTestValue, eLowValue, eHighValue)

WHERE BETWEEN(ytd_sales,4095,12000)


2. T-SQL
BETWEEN (T-SQL)

WHERE ytd_sales BETWEEN 4095 AND 12000

they both perform the same, if you are doing SQL pass through, T-SQL is needed. SQL in FoxPro requires the first.
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top