The “start of line” metacharacter (^) matches only at the start of the string, while the “end of line” metacharacter ($) matches only at the end of the string. If this modifier is set, letters in the pattern match both upper and lower case letters.īy default, SESAM/SQL treats the subject string as consisting of a single “line” of characters, even if it actually contains several NEWLINE characters (see 'CSV() - Reading a BS2000 file as a table'). The value of regular_expression may not be a multiple value with a dimension > 1.Īlphanumeric expression of the modifiers for regular_expression. You specify modifiers for regular_expression in the FLAG clause. For information on the structure of regular expressions, see 'LIKE_REGEX predicate (pattern comparison with regular expressions)'. The value of operand may not be a multiple value with a dimension > 1.Īlphanumeric expression whose value is a regular expression which the value of operand should match. Operand LIKE_REGEX regular_expression Īlphanumeric expression which presents the operand for the comparison with the regular expression. They have long been used, for example, in the Perl programming language. Regular expressions are a powerful means of searching large data sets for complex search conditions. Regular expressions are precisely defined search patterns which go far beyond the options of the search patterns in the LIKE predicate. A check is made to see whether an alphanumeric value matches a specified regular expression.

Manual mastercam v. 9.1