not-greater-than-transact-sql.md

description	!> (Not Greater Than) (Transact-SQL)
title	!> (Not Greater Than) (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/13/2017
ms.prod	sql
ms.prod_service	database-engine, sql-database
ms.reviewer
ms.technology	t-sql
ms.topic	reference
f1_keywords	Not Greater Greater !>_TSQL !> Not Greater Than
dev_langs	TSQL
helpviewer_keywords	!> (not greater than) not greater than operator (!>)
ms.assetid	71a413ed-64f1-4ab9-9c52-c5959a77d00f
author	cawrites
ms.author	chadam

!> (Not Greater Than) (Transact-SQL)

[!INCLUDE SQL Server SQL Database]

Compares two expressions (a comparison operator). When you compare non-null expressions, the result is TRUE if the left operand doesn't have a greater value than the right operand. Otherwise, the result is FALSE. Unlike the = (equality) comparison operator, the result of the !> comparison of two NULL values doesn't depend on the ANSI_NULLS setting.

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

See Also

Data Types (Transact-SQL)
Operators (Transact-SQL)