Using match values for character columns
If you are defining the validation rule for a character column,
you can use the Match button on the Definition page of the Validation
Rule view. This button lets you define a match pattern for matching
the contents of a column to a specified text pattern (for example,
^[0-9]+$ for all numbers and
^[A-Za-z]+$ for all letters).
To specify a match pattern for character columns:
-
Click the Match button on the Definition
page of the Validation Rule view.The Match Pattern dialog box displays.
-
Enter the text pattern you want to match the column
to, or select a displayed pattern. -
(Optional) Enter a test value and click the Test
button to test the pattern. -
Click OK when you are satisfied that the pattern
is correct.
For more on the Match function
and text patterns, see the DataWindow Reference.