This topic has not yet been rated - Rate this topic

< (Less Than) (SQL Server Compact)

SQL Server 2008 R2
SQL Server 2008
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.

Syntax

Copy


expression < expression

Arguments

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

Result Types

bit

Example

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

Copy

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)

Products

Resources

Solutions

Downloads

Evals

Tools

TechNet Support

Microsoft Support

< (Less Than) (SQL Server Compact)