SQL Server - Not Less than (!<) Operator

The SQL Server (Transact-SQL) !< (not less than) operator checks if the value of left operand is not less than the value of right operand and returns true if the condition is true, false otherwise.

Syntax

The syntax for using not less than operator in SQL Server (Transact-SQL) is given below:

expression !< expression

Parameters

expression Any valid expression. Both expressions must have implicitly convertible data types.

Example:

Consider a database table called Employee with the following records:

EmpID	Name	City	Age	Salary
1	John	London	25	3000
2	Marry	New York	24	2750
3	Jo	Paris	27	2800
4	Kim	Amsterdam	30	3100
5	Ramesh	New Delhi	28	3000
6	Huang	Beijing	28	2800

To select records of table where Age of the person is not less than 27, the query is given below.

SELECT * FROM Employee
WHERE Age !< 27;

The query will produce following result:

EmpID	Name	City	Age	Salary
3	Jo	Paris	27	2800
4	Kim	Amsterdam	30	3100
5	Ramesh	New Delhi	28	3000
6	Huang	Beijing	28	2800

❮ SQL Server Operators