A. Range rules
The following example creates a rule to restrict the integer range in the column bound to which the rule is inserted.
CREATE RULE RANGE_RULE
AS
@range> = $ 1000 and @Range <$ 20000
B. List rules
The following example creates a rule to limit the actual value in the columns that are bound to this rule to only the values listed in this rule.
CREATE RULE LIST_RULE
AS
@List in ('1389', '0736', '0877')
C. Mode rules
The following example creates a rule that follows this mode: followed by any two characters, follows a hyphen, and any number of characters (or no characters), and ends between 0 and 9.
Create rule pattern_rule
AS
@Value Like '_ _-% [0-9]'
