Skip to content

Latest commit

 

History

History
92 lines (66 loc) · 2.88 KB

less-than-transact-sql.md

File metadata and controls

92 lines (66 loc) · 2.88 KB
Raw
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs monikerRange
< (Less Than) (Transact-SQL)
&lt; (Less Than) (Transact-SQL)
rwestMSFT
randolphwest
03/13/2017
sql
t-sql
reference
<_TSQL
less than (<)
< (less than operator)
TSQL
>= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || >= sql-server-linux-2017 || = azuresqldb-mi-current||=fabric

< (Less Than) (Transact-SQL)

[!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw]

Compares two expressions (a comparison operator). When you compare nonnull expressions, the result is TRUE if the left operand has a value lower than the right operand; otherwise, the result is FALSE. If either or both operands are NULL, see the topic SET ANSI_NULLS (Transact-SQL).

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

expression < expression

[!INCLUDEsql-server-tsql-previous-offline-documentation]

Arguments

expression
Is any valid expression. Both expressions must have implicitly convertible data types. The conversion depends on the rules of data type precedence.

Result Types

Boolean

Examples

A. Using < in a simple query

The following example returns all rows in the HumanResources.Department table that have a value in DepartmentID that is less than the value 3.

-- Uses AdventureWorks  
  
SELECT DepartmentID, Name  
FROM HumanResources.Department  
WHERE DepartmentID < 3  
ORDER BY DepartmentID;

[!INCLUDEssResult]

DepartmentID Name  
------------ --------------------------------------------------  
1            Engineering  
2            Tool Design  
  
(2 row(s) affected)

B. Using < to compare two variables

DECLARE @a INT = 45, @b INT = 40;  
SELECT IIF ( @a < @b, 'TRUE', 'FALSE' ) AS Result;

[!INCLUDEssResult]

Result  
------  
FALSE  
  
(1 row(s) affected)

See Also