Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Determines whether an expression results in a value in a specified range. The Entity SQL BETWEEN expression has the same functionality as the Transact-SQL BETWEEN expression.
Syntax
expression [ NOT ] BETWEEN begin_expression AND end_expression
Arguments
expression
Any valid expression to test for in the range defined by begin_expression and end_expression. expression must be the same type as both begin_expression and end_expression.
begin_expression
Any valid expression. begin_expression must be the same type as both expression and end_expression. begin_expression should be less than end_expression, else the return value will be negated.
end_expression
Any valid expression. end_expression must be the same type as both expression and begin_expression.
NOT Specifies that the result of BETWEEN be negated.
AND
Acts as a placeholder that indicates expression should be within the range indicated by begin_expression and end_expression.
Return Value
true if expression is between the range indicated by begin_expression and end_expression; otherwise, false. null will be returned if expression is null or if begin_expression or end_expression is null.
Remarks
To specify an exclusive range, use the greater than (>) and less than (<) operators instead of BETWEEN.
Example
The following Entity SQL query uses BETWEEN operator to determine whether an expression results in a value in a specified range. The query is based on the AdventureWorks Sales Model. To compile and run this query, follow these steps:
Follow the procedure in How to: Execute a Query that Returns StructuralType Results.
Pass the following query as an argument to the
ExecuteStructuralTypeQuerymethod:
SELECT VALUE product FROM AdventureWorksEntities.Products
AS product where product.ListPrice BETWEEN @price1 AND @price2