Query Operator Reference

2013-04-10

Product Documentation

Intermediate

Operators can be entered when using Quick Query, Query Builder, or when creating an SQL Query.

Query Operators
Operator	Description
Equal (=)	Returns all records that exactly match the value that you specify.
Not equal (<>)	Returns all records except those matching the value that you specify.
Greater than (>)	Returns all records that exceed the value that you specify.
Less than (<)	Returns all records with values that are less than the value that you specify.
Greater than or equal (>=)	Returns all records that exceed or equal the value that you specify.
Less than or equal (<=)	Returns all records that are less than or equal to the value that you specify.
Like	Returns all records that contain the value that you specify. Using the like operator, you can specify the optional % wild-card character. If, for example, you want to return all records that end with the string "ert", you enter the value %ert. If you want to return all records that begin with the string "ert", you enter the value ert%. If you don't specify the % wild-card character, the program searches for the exact value that you specify.
In	Returns all records that match a set of values that you specify. If, for example, you are searching for an employee record but are not sure if the name is spelled Smith or Smythe, you could issue the in operator and provide both spelling values to return all records spelled either Smith or Smythe. The two values must be separated by a comma.
Is null	Returns all records that do not have values specified for the field that you're querying. This operator is useful for locating records in your database table that are missing data.
Is not null	Returns all records that have values specified for the field that you're querying. This operator is useful for excluding from your query any records in your database table that are missing data.

Was this information helpful?

Yes
No