The syntax of the WHERE clause with a BETWEEN phrase : Between « Query « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Query
  3. Between
WHERE test_expression [NOT] BETWEEN begin_expression AND end_expression








1.9.Between
1.9.1.The syntax of the WHERE clause with a BETWEEN phrase
1.9.2.A BETWEEN phrase preceded by NOT
1.9.3.A BETWEEN phrase with the upper and lower limits coded as calculated values
1.9.4.A BETWEEN phrase with literal values
1.9.5.A BETWEEN phrase with a test expression coded as a calculated value
1.9.6.NOT BETWEEN operator can be used to search for column values that do not fall within the specified range
1.9.7.The BETWEEN operator searches for all values in the range inclusively
1.9.8.The BETWEEN operator is logically equal to two individual comparisons, which are connected with the Boolean operator AND.