Operators in SQL Server

An operator is a symbol specifying an action that is performed on one or more expressions. The following table lists the operator categories that SQL Server uses.

The Logical Operators in SQL perform the Boolean operations, which give two results True and False. These operators provide True value if both operands match the logical condition.

Following are the various logical operators which are performed on the data stored in the SQL database tables:

  1. SQL ALL operator
  2. SQL AND operator
  3. SQL OR operator
  4. SQL BETWEEN operator
  5. SQL IN operator
  6. SQL NOT operator
  7. SQL ANY operator
  8. SQL LIKE operator

AND operator in SQL Server

The AND operator in SQL Server is used to combine two or more conditions in a WHERE clause. It returns true only if all the conditions are true.

IN & OR operator in SQL Server

The OR operator in SQL Server is used to combine two or more conditions in a WHERE clause. It returns true if any of the conditions are true

Between operator in SQL Server

The BETWEEN operator in SQL Server is used to specify a range of values in a WHERE clause. It returns true if the value being tested is within the specified range.

Like Operator in SQL Server

The LIKE operator in SQL Server is used in a WHERE clause to search for a specified pattern in a column. It allows you to use wildcards to match one or more characters in a string.

NOT operator in SQL Server

The NOT operator in SQL Server is used to negate a Boolean expression in the WHERE clause of a SELECT, UPDATE, or DELETE statement. It returns true if the expression is false and false if the expression is true. Here is an example of how to use the NOT operator in SQL Server