Showing posts with label operators. Show all posts
Showing posts with label operators. Show all posts

Monday, September 14, 2009

Operators allowed in where condition

Operators Allowed in the WHERE Clause

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

Ads

Your Ad Here