scope:

This Technical Report describes the regular expression support in SQL adopted from the regular expression syntax of [XQuery F&O], which is derived from Perl. This Technical Report discusses five operators using this regular expression syntax:

- LIKE_REGEX predicate, to determine the existence of a match to a regular expression.

- OCCURRENCES_REGEX numeric function, to determine the number of matches to a regular expression.

- POSITION_REGEX function, to determine the position of a match.

- SUBSTRING_REGEX function, to extract a substring matching a regular expression.

- TRANSLATE_REGEX function, to perform replacements using a regular expression.