Operators are used in WHERE clauses to perform arithmetic, comparison, logical and string operations.

The following pages and posts are tagged with

TitleTypeSummary
Addition Page Adds two numeric values.
BETWEEN Page Determines whether a value is within a specified range defined by two boundaries.
Concatenation Page Concatenates two string values.
Division Page Divides one numeric value into another numeric value.
Equals Page Compares two expressions for equivalence, and returns a true value if they are found to be equal. Syntax
EXCEPT and INTERSECT Page Compares two queries and returns distinct rows only based on the keyword provided.
Greater Than Page Compares two expressions, and returns true if the first value is greater than the second value.
Greater Than or Equal To Page Compares two expressions, and returns true if the first value is greater than or equal to the second value.
IN Page Determines whether a value is within a specified range, defined by a subquery, expression, or list.
IS [ NOT ] NULL Page Compares an expression or value and determines whether it is NULL.
Less Than Page Compares two expressions, and returns true if the first value is less than the second value.
Less Than or Equal To Page Compares two expressions, and returns true if the first value is less than or equal to the second value.
LIKE Page Compares a character value to a specified character pattern.
Multiplication Page Multiplies two numeric values.
Not Equal Page Compares two expressions for equivalence, and returns a true value if they are found to be unequal.
Subtraction Arithmetic Operator Page Subtracts two numeric values.