regexp_match
Matches a string against a regular expression pattern.
Syntax
regexp_match(<expr>, <pattern>)
| Parameter | Type | Description |
|---|---|---|
| expr | Text | The expression to evaluate. |
| pattern | Text | The Pattern string value. |
Return values
Text
Usage
Matches the email address against a regular expression pattern.
regexp_match(orders.email, '^[a-z]+@[a-z]+\\.com$')