Operators

The basic form of elements in the WHERE clause for simple operators is:

[NOT] <column> Operator “Value”

= or EQ - Equal to.

< or LT - Less than.

> or GT - Greater than.

<= or LE - Less than or equal to.

>= or GE - Greater than or equal to.

<> or NE - Not equal to.

For the BETWEEN operators:

[NOT] <column> [X]BETWEEN “Lower” AND “Upper”

For the IN operator:

[NOT] <column> IN ( <comma separated list of values> )

In these cases, values can be replaced with sub-selects. To test for Null use the IS operator and the keyword Null:

[NOT] <column> IS NULL

Note:

The data for a TEXT column must be included inside quotation marks, e.g. "F". Quotation marks are not necessary for numeric columns.

When using <,<=,> or >= it is important to realize that for TEXT columns the comparison is alphanumeric (e.g. "SMITH" is greater than "BROWN" and more importantly "2" is greater than "1000"). This demonstrates the importance of loading the field data with the correct data type (a numeric field mistakenly imported as text could return some unexpected results).

	Online & Instructor-Led Courses \| Training Videos \| Webinar Recordings
	© Alterian. All Rights Reserved. \| Privacy Policy \| Legal Notice