Monday, November 03, 2008

SQL Operators

These operators are generally used in SQL like with WHERE clause. You can use any one operator or any number of operators (Unless it is logically and Syntax Correct)

Operator Description
= Equal
<> Not equal
> Greater than
< Less than
>= Greater than or equal
<= Less than or equal
BETWEEN Between an inclusive range
LIKE

Search for a pattern

IN If you know the exact value you want to return for at least one of the columns