Databases for Windows  /   Database Blog  /   Organizer Advantage, Handy Library, SQL Tutor  /   SQL Select   /  SQL Tutor, Select Where Clouse, Comparison Operators

SQL SELECT, WHERE clause, Comparison Operators

SQL SELECT, WHERE clause, Operators

When you define the condition in the WHERE clause, you can use comparison operators. Operators are necessary to define a condition (comparison operators); they also act as a connector between two or more conditions (logical operators).

Where condition, operators

When you define the condition in the WHERE clause, you can use the following comparison operators.

= (equal)
> (greater than)
< (less than)
>= (greater than or equal)
<= (less than or equal)
<> (not equal. Note: In some versions of SQL this operator may be written as !=)
BETWEEN (between a certain range)
LIKE (search for a pattern)
IN (specify multiple possible values for a column)

Organizer Advantage, Simple Database Solutions

Organizer Advantage, Business Database Solutions

Organizer Advantage Free Service

Organizer Advantage Support

Handy Managers

Handy Library Manager

Handy Equipment Tool Manager