A.5.2 List Regular Expression Matching
The 'match' operator matches a string value with a regular expression.
company match 'I.*'
Similar to the 'like' operator, a logic negation can be added with a 'shorthand' method.
company not match 'I.*'
Like the list comparison expression, a list of values can be matched against a regular expression. The comparison can be defined as either 'Any' or 'All'.
any skill match 'C.*Programming'
For the 'Any' type list matching, the result is true if any value in the list matches the regular expression. For an 'All' type list matching, the result is only true if all values in the list match the regular expression.
| << A.5.1 Regular Expression Operator | © 1996-2013 InetSoft Technology Corporation (v11.5) | A.6 Aggregate Functions >> |