2 out of 9 rated this helpful - Rate this topic

<= (Less Than or Equal To) (Transact-SQL)

SQL Server 2012

Compares two expressions (a comparison operator). When you compare nonnull expressions, the result is TRUE if the left operand has a value lower than or equal to the right operand; otherwise, the result is FALSE.

Unlike the = (equality) comparison operator, the result of the >= comparison of two NULL values does not depend on the ANSI_NULLS setting.

Topic link icon Transact-SQL Syntax Conventions

Syntax

expression <= expression

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 or equal to the value 3.

USE AdventureWorks2012;
GO
SELECT DepartmentID, Name
FROM HumanResources.Department
WHERE DepartmentID <= 3
ORDER BY DepartmentID;

Here is the result set.

DepartmentID Name
------------ --------------------------------------------------
1            Engineering
2            Tool Design
3            Sales

(3 row(s) affected)

Reference

Data Types (Transact-SQL)

Operators (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD