SQL Server Articles

Submit Article
Home » Articles » SQL Server » Operator RSS Feeds

Comparison operators

Posted By: Sarita Patel     Category: SQL Server     Views: 2602

This article explains different comparison operators available in SQL server with example.

Comparison operators are used to compare two expressions. It can be used with any type of expression except text, ntext or image data type.

Different Comparison Operators : 



=  ( Equals )

Equal to

>  ( Greater Than )

Greater than

<  ( Less Than )

Less than

>=  ( Greater Than or Equal To )

Greater than or equal to

<=  ( Less Than or Equal To )

Less than or equal to

<>  ( Not Equal To )

Not equal to

!=  ( Not Equal To )

Not equal to 

!<  ( Not Less Than )

Not less than 

!>  ( Not Greater Than )

Not greater than 


Didn't find what you were looking for? Find more on Comparison operators Or get search suggestion and latest updates.

Sarita Patel
Sarita Patel author of Comparison operators is from United States.
View All Articles

Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

No Comment Found, Be the First to post comment!