Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
 SQL Server  
 Azure SQL Database 
 Azure SQL Managed Instance 
 SQL database in Microsoft Fabric Preview
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  
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