Between AND : Select Query : SQL Server / T-SQL examples (example source code) Organized by topic

Java Java Tutorial Java Articles Java Products Java by API C# / C Sharp ASP.Net JavaScript DHTML JavaScript Reference HTML / CSS HTML CSS Reference C / ANSI-C C++ PHP Python SQL Server / T-SQL Oracle PL/SQL PostgreSQL SQL / MySQL VB.Net

SQL Server / T-SQL Home »  Select Query   » [  Between AND  ]

1.  BETWEEN operator specifies a range: determines the lower and upper bounds of qualifying values
2.  Use 'Between ... and' operator on a date data type
3.  'Between and' for a number data type
4.  Not 'Between...and'
5.  BETWEEN operator is equal to two individual comparisons, which are connected with the Boolean operator AND