How To Construct a Validation Rule for Numeric Fields

The available pattern symbols for constructing numeric validation rules are

The available syntax characters for constructing numeric validation rules are

-

Denote a range of numbers.

|

Separates alternative numbers or ranges of numbers.

Examples of Numeric Validation Rules

The following table contains examples of numeric validation rules, and the values that can be legal or illegal under those rules:

Validation Rule

Legal Value

Illegal Value

1|2|3|5

1 or 2 or 3 or 5

0 or 4 or 6

10-20

From 10 to 20, inclusive.
10.123 is also legal. (Use DataMask to control the number of decimal places permitted in the field.)

0-9 or 21

10-20|100-200

From 10 to 20, or from 100 to 200, inclusive

0-9 or 21-99 or 201

-30--5|1|1.3-1.7

From -30 to -5, or 1, or from 1.3 to 1.7

-4-0 or 1.8 or 2