Operators for Searching Numeric Fields


The sections below describe operators used to search numeric and date fields.

= (Equals)

Selects documents whose document field values are exactly the same as the search string you specify.

For example, assume a document field named ORGNO has been defined as the number of the organization that wrote the document. To select only those documents written by organization 104, enter the following:

ORGNO = 104

!= (Not Equals)

Selects documents whose document field values do not match the search string you specify.

For example, to search for documents with ORGNO field values not equal to 104, use this query:

ORGNO != 104

Another query using the NOT modifier could be used to perform the same search:

<NOT>(ORGNO=104)

Although using the NOT modifier returns the same results as using the != operator, the != operator functions much more efficiently.

> (Greater Than)

Selects documents whose document field values are greater than the search string you specify.

For example, assume a document field named REVISION has been defined. To select only those documents that have been revised more than three times, enter the following:

REVISION > 3

>= (Greater Than Or Equal To)

Selects documents whose document field values are greater than or equal to the search string you specify.

For example, assume a document field named REVISION has been defined. To select only those documents that have been revised three times or more, enter the following:

REVISION >= 3

< (Less Than)

Selects documents whose document field values are less than the search string you specify.

For example, assume a document field named PAGES has been defined. To select only those documents less than five pages long, enter the following:

PAGES < 5

<= (Less Than Or Equal To)

Selects documents whose document field values are less than or equal to the search string you specify.

For example, assume a document field named DATE has been defined. To select only those documents dated prior to and including February 14, 1991, enter the following:

DATE <= 02-14-91





Copyright © 2001, Verity, Inc. All rights reserved.