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!

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

Correct usage of BETWEEN

SQL Syntax

Correct usage of BETWEEN

by  myearwood  Posted    (Edited  )
The BETWEEN function should be used in all non SQL situations in VFP. In all SQL avoid the use of the BETWEEN() function as it will make it harder for you to do straight SQL outside of VFP.

While this is possible
Code: 
SELECT * FROM TABLE WHERE BETWEEN(DATEFIELD,ONEDATE,ANOTHERDATE)

this is more SQL compatible
Code: 
SELECT * FROM TABLE WHERE DATEFIELD BETWEEN ONEDATE AND ANOTHERDATE
Register to add this FAQ to your archive
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