The following table lists the available regular expression functions, and a description of their purpose.
| Function | Description |
|---|---|
| REGEXP_SUBSTR | Extracts a substring from source_string that matches a regular expression specified by regexp_string. |
| REGEXP_REPLACE | Replaces portions of source_string that match regexp_string with the replace_string. |
| REGEXP_INSTR | Searches source_string for a match to regexp_string. |
| REGEXP_SIMILAR | Compares source_string to regexp_string and returns integer value: REGEXP_SIMILAR provides semantics comparable to the SIMILAR predicate in ANSI-SQL-99. |
See the Teradata Database SQL Functions, Operators, Expressions, and Predicates document, B035-1145, for a detailed overview of these regular expression functions.