Specifications

Max
704 InfoMaker
Sample patterns
The following table shows various text patterns and sample
text that matches each pattern:
Examples This validation rule checks that the value the user entered begins with an
uppercase letter. If the value of the expression is false, the data fails validation:
Match(GetText(), "^[A-Z]")
See also
Pos
Max
Description Gets the maximum value in the specified column.
Syntax Max ( column { FOR range { DISTINCT { expres1 {, expres2 {, ... } } } } } )
This pattern Matches
AB Any string that contains AB, such as ABA, DEABC,
graphAB_one.
B* Any string that contains 0 or more Bs, such as AC, B, BB,
BBB, ABBBC, and so on. Since B* used alone matches any
string, you would not use it alone, but notice its use in some
the following examples.
AB*C Any string containing the pattern AC or ABC or ABBC, and
so on (0 or more Bs).
AB+C Any string containing the pattern ABC or ABBC or
ABBBC, and so on (1 or more Bs).
ABB*C Any string containing the pattern ABC or ABBC or
ABBBC, and so on (1 B plus 0 or more Bs).
^AB Any string starting with AB.
AB?C Any string containing the pattern AC or ABC (0 or 1 B).
^[ABC] Any string starting with A, B, or C.
[^ABC] A string containing any characters other than A, B, or C.
^[^abc] A string that begins with any character except a, b, or c.
^[^a-z]$ Any single-character string that is not a lowercase letter (^
and $ indicate the beginning and end of the string).
[A-Z]+ Any string with one or more uppercase letters.
^[0-9]+$ Any string consisting only of digits.
^[0-9][0-9][0-9]$ Any string consisting of exactly three digits.
^([0-9][0-9][0-9])$ Any string consisting of exactly three digits enclosed in
parentheses.