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 2005

Product Documentation

SQL Server 2005 Documentation

SQL Server 2005 Compact Edition Books Online

SQL Server Compact Edition Programming

SQL Reference (SQL Server Compact Edition)

SQL Overview (SQL Server Compact Edition)

+ (Add) (SQL Server Compact Edition)

+ (Positive) (SQL Server Compact Edition)

+ (String Concatenation) (SQL Server Compact Edition)

- (Subtract) (SQL Server Compact Edition)

- (Negative) (SQL Server Compact Edition)

* (Multiply) (SQL Server Compact Edition)

/ (Divide) (SQL Server Compact Edition)

% (Modulo) (SQL Server Compact Edition)

& (Bitwise AND) (SQL Server Compact Edition)

| (Bitwise OR) (SQL Server Compact Edition)

^ (Bitwise Exclusive OR) (SQL Server Compact Edition)

~ (Bitwise NOT) (SQL Server Compact Edition)

= (Equals) (SQL Server Compact Edition)

> (Greater Than) (SQL Server Compact Edition)

< (Less Than) (SQL Server Compact Edition)

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

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

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

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

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

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

@@IDENTITY (SQL Server Compact Edition)

ABS (SQL Server Compact Edition)

ACOS (SQL Server Compact Edition)

ALL (SQL Server Compact Edition)

ALTER TABLE (SQL Server Compact Edition)

AND (SQL Server Compact Edition)

ASIN (SQL Server Compact Edition)

ATAN (SQL Server Compact Edition)

ATN2 (SQL Server Compact Edition)

AVG (SQL Server Compact Edition)

BETWEEN (SQL Server Compact Edition)

CASE (SQL Server Compact Edition)

CEILING (SQL Server Compact Edition)

CHARINDEX (SQL Server Compact Edition)

COALESCE (SQL Server Compact Edition)

COLLATE (SQL Server Compact Edition)

CONVERT (SQL Server Compact Edition)

COS (SQL Server Compact Edition)

COT (SQL Server Compact Edition)

COUNT (SQL Server Compact Edition)

CREATE DATABASE (SQL Server Compact Edition)

CREATE INDEX (SQL Server Compact Edition)

CREATE STATISTICS (SQL Server Compact Edition)

CREATE TABLE (SQL Server Compact Edition)

DATALENGTH (SQL Server Compact Edition)

DATEADD (SQL Server Compact Edition)

DATEDIFF (SQL Server Compact Edition)

DATENAME (SQL Server Compact Edition)

DATEPART (SQL Server Compact Edition)

DDL Statements (SQL Server Compact Edition)

DEGREES (SQL Server Compact Edition)

DELETE (SQL Server Compact Edition)

DML Statements (SQL Server Compact Edition)

DROP INDEX (SQL Server Compact Edition)

DROP STATISTICS (SQL Server Compact Edition)

DROP TABLE (SQL Server Compact Edition)

EXISTS (SQL Server Compact Edition)

EXP (SQL Server Compact Edition)

Expressions (SQL Server Compact Edition)

FLOOR (SQL Server Compact Edition)

FROM Clause (SQL Server Compact Edition)

Functions (SQL Server Compact Edition)

GETDATE (SQL Server Compact Edition)

GROUP BY Clause (SQL Server Compact Edition)

HAVING Clause (SQL Server Compact Edition)

Hints (SQL Server Compact Edition)

IDENTITY Property (SQL Server Compact Edition)

IN (SQL Server Compact Edition)

Information Schema (SQL Server Compact Edition)

INSERT (SQL Server Compact Edition)

IS [NOT] NULL (SQL Server Compact Edition)

LEN (SQL Server Compact Edition)

LIKE (SQL Server Compact Edition)

LOG (SQL Server Compact Edition)

LOG10 (SQL Server Compact Edition)

LOWER (SQL Server Compact Edition)

LTRIM (SQL Server Compact Edition)

MAX (SQL Server Compact Edition)

MIN (SQL Server Compact Edition)

NCHAR (SQL Server Compact Edition)

NEWID (SQL Server Compact Edition)

NOT (SQL Server Compact Edition)

Operators (SQL Server Compact Edition)

OR (SQL Server Compact Edition)

ORDER BY Clause (SQL Server Compact Edition)

PATINDEX (SQL Server Compact Edition)

PI (SQL Server Compact Edition)

POWER (SQL Server Compact Edition)

RADIANS (SQL Server Compact Edition)

RAND (SQL Server Compact Edition)

REPLACE (SQL Server Compact Edition)

REPLICATE (SQL Server Compact Edition)

Reserved Words (SQL Server Compact Edition)

ROUND (SQL Server Compact Edition)

RTRIM (SQL Server Compact Edition)

SELECT Statement (SQL Server Compact Edition)

SIGN (SQL Server Compact Edition)

SIN (SQL Server Compact Edition)

SOME | ANY (SQL Server Compact Edition)

sp_show_statistics (SQL Server Compact Edition)

SPACE (SQL Server Compact Edition)

SQRT (SQL Server Compact Edition)

STR (SQL Server Compact Edition)

STUFF (SQL Server Compact Edition)

SUBSTRING (SQL Server Compact Edition)

SUM (SQL Server Compact Edition)

TAN (SQL Server Compact Edition)

UNICODE (SQL Server Compact Edition)

UNION (SQL Server Compact Edition)

UPDATE (SQL Server Compact Edition)

UPDATE STATISTICS (SQL Server Compact Edition)

UPPER (SQL Server Compact Edition)

USE (SQL Server Compact Edition)

WHERE Clause (SQL Server Compact Edition)

Minimize

This topic has not yet been rated - Rate this topic

< (Less Than) (SQL Server Compact Edition)

SQL Server 2005

Compares two expressions. When you compare nonnull expressions by using this operator, the result is TRUE when the left operand has a value lower than the right operand. Otherwise, the result is FALSE.


expression < expression

expression: Any valid expression in Microsoft SQL Server 2005 Compact Edition. Both expressions must have implicitly convertible data types. The conversion depends on the rules of data type precedence.

bit

The following example uses the less than comparison operator to find all orders in the Order Details table with quantities fewer than 10 units.

SELECT * FROM "Order Details" WHERE Quantity < '10'

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.