Skip to content

less-than-transact-sql.md

Latest commit

 

History

History
95 lines (69 loc) · 3.03 KB

less-than-transact-sql.md

File metadata and controls

95 lines (69 loc) · 3.03 KB
title < (Less Than) (Transact-SQL)
description &lt; (Less Than) (Transact-SQL)
author rwestMSFT
ms.author randolphwest
ms.reviewer
ms.date 03/13/2017
ms.prod sql
ms.prod_service database-engine, sql-database, synapse-analytics, pdw
ms.technology t-sql
ms.topic reference
ms.custom
f1_keywords
<_TSQL
helpviewer_keywords
less than (<)
< (less than operator)
dev_langs
TSQL
monikerRange >= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || >= sql-server-linux-2017 || = azuresqldb-mi-current

< (Less Than) (Transact-SQL)

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

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).

Topic link icon 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