Open topic with navigation

# NRANGE

The `NRANGE` field specifier (case sensitive) allows you to find documents in which a specified field contains a number that falls within the inclusive range of two specified numbers.

NOTE:

You can optimize the field specifier speed by restricting the field to the `NumericType` property type.

## Format

    FieldText=NRANGE{yourNumbers}:yourFields

`yourNumbers` | Two numbers separated by a comma (there must be no space before or after the comma). A document returns only if one of `yourFields` contains a number that falls within the inclusive range of the specified numbers (including decimal numbers). By default, the range is inclusive. You can use the greater than (<) and less than (>) symbols to specify an exclusive range. You can make either or both ends of the range exclusive.
`yourFields` | One or more fields. A document returns only if it contains one of these fields, and if this field contains a number that falls within the inclusive range of `yourNumbers`. Separate multiple fields with colons (`:`). There must be no space before or after a colon.

## Example

    FieldText=NRANGE{1,99}:CODE

The `CODE` field must contain a number between 1 and 99 (inclusive) for this document to return.

    FieldText=NRANGE{1234567890123,2345678901234}:ACCOUNT:KONTO

The `ACCOUNT` or `KONTO` field must contain a number between `1234567890123` and `2345678901234` (inclusive) for this document to return.

    FieldText=NRANGE{36.5,42.3}:CODE

The `CODE` field must contain a number between 36.5 and 42.3 (inclusive) for this document to return.

    FieldText=NRANGE{>1,5}:CODE

The `CODE` field must contain a value that is greater than 1, up to and including 5.

© 2018 Micro Focus or one of its affiliates | Send documentation feedback to Micro Focus Close Send documentation feedback To open the configured email client on this computer, open an email window. Otherwise, copy the information below to a web mail client, and send this email to swpdl.idoldocsfeedback@microfocus.com. We appreciate your feedback! Product: Topic Title: Help Topic: Feedback:

_FT_HTML5_bannerTitle.htm