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 section called “Match” in DataWindow Reference.