BETWEEN (SQL Server Compact)

SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server Compact

SQL Server Compact 3.5 SP2

SQL Server Compact Technical Reference

SQL Reference (SQL Server Compact)

SQL Overview (SQL Server Compact)

+ (Add) (SQL Server Compact)

+ (Positive) (SQL Server Compact)

+ (String Concatenation) (SQL Server Compact)

- (Subtract) (SQL Server Compact)

- (Negative) (SQL Server Compact)

* (Multiply) (SQL Server Compact)

/ (Divide) (SQL Server Compact)

% (Modulo) (SQL Server Compact)

& (Bitwise AND) (SQL Server Compact)

| (Bitwise OR) (SQL Server Compact)

^ (Bitwise Exclusive OR) (SQL Server Compact)

~ (Bitwise NOT) (SQL Server Compact)

= (Equals) (SQL Server Compact)

> (Greater Than) (SQL Server Compact)

< (Less Than) (SQL Server Compact)

>= (Greater Than or Equal To) (SQL Server Compact)

<= (Less Than or Equal To) (SQL Server Compact)

<> (Not Equal To) (SQL Server Compact)

!= (Not Equal To) (SQL Server Compact)

!< (Not Less Than) (SQL Server Compact)

!> (Not Greater Than) (SQL Server Compact)

@@IDENTITY (SQL Server Compact)

@@DBTS (SQL Server Compact)

@@SHOWPLAN (SQL Server Compact)

ABS (SQL Server Compact)

ACOS (SQL Server Compact)

ALL (SQL Server Compact)

ALTER TABLE (SQL Server Compact)

AND (SQL Server Compact)

ASIN (SQL Server Compact)

ATAN (SQL Server Compact)

ATN2 (SQL Server Compact)

AVG (SQL Server Compact)

BETWEEN (SQL Server Compact)

CASE (SQL Server Compact)

CEILING (SQL Server Compact)

CHARINDEX (SQL Server Compact)

COALESCE (SQL Server Compact)

COLLATE (SQL Server Compact)

CAST and CONVERT (SQL Server Compact)

COS (SQL Server Compact)

COT (SQL Server Compact)

COUNT (SQL Server Compact)

CREATE DATABASE (SQL Server Compact)

CREATE INDEX (SQL Server Compact)

CREATE STATISTICS (SQL Server Compact)

CREATE TABLE (SQL Server Compact)

DATALENGTH (SQL Server Compact)

DATEADD (SQL Server Compact)

DATEDIFF (SQL Server Compact)

DATENAME (SQL Server Compact)

DATEPART (SQL Server Compact)

DDL Statements (SQL Server Compact)

DEGREES (SQL Server Compact)

DELETE (SQL Server Compact)

DML Statements (SQL Server Compact)

DROP INDEX (SQL Server Compact)

DROP STATISTICS (SQL Server Compact)

DROP TABLE (SQL Server Compact)

EXISTS (SQL Server Compact)

EXP (SQL Server Compact)

Expressions (SQL Server Compact)

FLOOR (SQL Server Compact)

FROM Clause (SQL Server Compact)

Functions (SQL Server Compact)

GETDATE (SQL Server Compact)

GROUP BY Clause (SQL Server Compact)

HAVING Clause (SQL Server Compact)

Hints (SQL Server Compact)

IDENTITY Property (SQL Server Compact)

IN (SQL Server Compact)

Information Schema (SQL Server Compact)

INSERT (SQL Server Compact)

IS [NOT] NULL (SQL Server Compact)

LEN (SQL Server Compact)

LIKE (SQL Server Compact)

LOG (SQL Server Compact)

LOG10 (SQL Server Compact)

LOWER (SQL Server Compact)

LTRIM (SQL Server Compact)

MAX (SQL Server Compact)

MIN (SQL Server Compact)

NCHAR (SQL Server Compact)

NEWID (SQL Server Compact)

NOT (SQL Server Compact)

Operators (SQL Server Compact)

OR (SQL Server Compact)

ORDER BY Clause (SQL Server Compact)

PATINDEX (SQL Server Compact)

PI (SQL Server Compact)

POWER (SQL Server Compact)

RADIANS (SQL Server Compact)

RAND (SQL Server Compact)

REPLACE (SQL Server Compact)

REPLICATE (SQL Server Compact)

Reserved Words (SQL Server Compact)

ROUND (SQL Server Compact)

RTRIM (SQL Server Compact)

SELECT Statement (SQL Server Compact)

SET IDENTITY INSERT (SQL Server Compact)

SET SHOWPLAN_XML (SQL Server Compact)

SET STATISTICS XML (SQL Server Compact)

SIGN (SQL Server Compact)

SIN (SQL Server Compact)

SOME | ANY (SQL Server Compact)

sp_show_statistics (SQL Server Compact)

sp_rename (SQL Server Compact)

SPACE (SQL Server Compact)

SQRT (SQL Server Compact)

STR (SQL Server Compact)

STUFF (SQL Server Compact)

SUBSTRING (SQL Server Compact)

SUM (SQL Server Compact)

TAN (SQL Server Compact)

timestamp (SQL Server Compact)

TOP (SQL Server Compact)

UNICODE (SQL Server Compact)

UNION (SQL Server Compact)

UPDATE (SQL Server Compact)

UPDATE STATISTICS (SQL Server Compact)

UPPER (SQL Server Compact)

USE (SQL Server Compact)

WHERE Clause (SQL Server Compact)

Minimize

1 out of 1 rated this helpful - Rate this topic

SQL Server 2008 R2

Specifies a range to test.

test_expression [ NOT ] BETWEEN begin_expression AND end_expression

test_expression: The expression to test for in the range defined by begin_expression and end_expression. The test_expression must be the same data type as both begin_expression and end_expression.
NOT: Specifies that the result of the predicate be negated.
begin_expression: Any valid expression in Microsoft SQL Server Compact 3.5. The begin_expression must be the same data type as both test_expression and end_expression.
end_expression: Any valid expression in SQL Server Compact 3.5. end_expression must be the same data type as both test_expression and begin_expression.
AND: Acts as a placeholder indicating that test_expression should be within the range indicated by begin_expression and end_expression.

bit

BETWEEN returns TRUE if the value of test_expression is greater than or equal to the value of begin_expression and less than or equal to the value of end_expression.

NOT BETWEEN returns TRUE if the value of test_expression is less than the value of begin_expression or greater than the value of end_expression.

To specify an exclusive range, use the greater than (>) and less than (<) operators. If any input to the BETWEEN or NOT BETWEEN predicate is NULL, the result is UNKNOWN.

The following example identifies products in a database with 35 or fewer units in stock.

SELECT [Product ID], [Product Name] FROM Products WHERE [Units In Stock] BETWEEN '0' AND '35'

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.