Sullivan Market

a web based full-circle development system

My SQL Tutorials - Between

Range Test (BETWEEN):      The range test checks whether a data value lies between two specified values. This test involves three SQL expressions. 1. The first defines the value to be tested. 2. The second and third define the low and the high ends of the range to be checked. The data types of the three expressions must be comparable. Here is a example that explains a Range Test... 

Select Column1, Column2
From TableName
Where ColumnName between "Value1" and "Value2";

Back To SQL Tutorials