# Operators Overview

## Arithmetic Operators

Name Description
%,MOD Modulo operator
* Multiplication operator
- Minus operator
- Change the sign of the argument
/ Division operator
DIV Integer division

Name Description
= Equal operator

## Bit Functions and Operators

Name Description
& Bitwise AND
>> Right shift
<< Left shift
^ Bitwise XOR
[ ](bit-functions-and-operators/bitwise-or.md)
~ Bitwise inversion

## Cast Functions and Operators

Name Description
CAST() Cast a value as a certain type
CONVERT() Cast a value as a certain type

## Comparison Functions and Operators

Name Description
> Greater than operator
>= Greater than or equal operator
< Less than operator
<>,!= Not equal operator
<= Less than or equal operator
= Equal operator
BETWEEN ... AND ... Whether a value is within a range of values
IN() Whether a value is within a set of values
IS Test a value against a boolean
IS NOT Test a value against a boolean
IS NOT NULL NOT NULL value test
IS NULL NULL value test
LIKE Simple pattern matching
NOT BETWEEN ... AND ... Whether a value is not within a range of values
NOT LIKE Negation of simple pattern matching
COALESCE Return the first non-null value in a list

## Flow Control Functions

Name Description
CASE Case operator
IF() If/else construct

## Logical Operators

Name Description
AND,&& Logical AND
NOT,! Negates value
OR Logical OR
XOR Logical XOR