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.
