Contract Number Ranges

Contract number is an alphanumeric attribute. The contract number range includes all contracts with a value equal to or greater than the From value but less than or equal to the To value.

Tip: If you use contract number ranges extensively, then use a fixed length numeric contract number. Using a fixed length numeric contract number simplifies the process of defining the contract number range and makes it more comprehensive. Precede the contract number with the required number of zeros to ensure that the length is always fixed.

Note: Spaces and letters are sorted before numbers when you sort a list of contract numbers.

Valid Contract Number Range Examples

The From and To contract numbers of 2009 through 2010 include the following contracts:

• All contracts that start with 2009 and contain extra trailing characters, such as 20090 and 2009AZ, since they all have a value greater than 2009.

• Contract 201, since it has a value less than 2010.

• All contracts that start with 201 and with a letter in position 4, such as 201A123Z, since they all have a value less than 2010.

The From and To contract numbers of 2009 through 2010 exclude the following contracts:

• Contracts 2 and 20, since they both have lower values than 2009.

• Contract 20A9XYZ, since it has a lower value than 2009.

• All contracts that start with 2010 and contain extra trailing characters, such as 20100 and 2010XYZ, since they all have values greater than 2010.