SQL Eval Function Regex
Represents an immutable regular expression.
| Name | Description | Example |
|---|---|---|
| Regex_Escape(input) | Escapes a minimal set of characters by replacing them with their escape codes. | Try it |
| Regex_Index(input, pattern) | Returns the position in the original string where the first character of the captured substring is found. | Try it |
| Regex_IndexOp(input, pattern, options) | Returns the position in the original string where the first character of the captured substring is found using the specified matching options. | Try it |
| Regex_IsMatch(input, pattern) | Indicates whether the specified regular expression finds a match in the specified input string. | Try it |
| Regex_IsMatchOp(input, pattern, options) | Indicates whether the specified regular expression finds a match in the specified input string using the specified matching options. | Try it |
| Regex_Match(input, pattern) | Searches an input string for a substring that matches a regular expression pattern and returns the first occurrence of that string. | Try it |
| Regex_MatchOp(input, pattern, options) | Searches an input string for a substring that matches a regular expression pattern and returns the first occurrence of that string using the specified matching options. | Try it |
| Regex_Replace(input, pattern, replacement) | Replaces all strings that match a specified regular expression with a specified replacement string. | Try it |
| Regex_ReplaceOp(input, pattern, replacement, options) | Replaces all strings that match a specified regular expression with a specified replacement string using the specified matching options. | Try it |
| Regex_Split(input, pattern, replacement) | Splits an input string into an array of substrings at the positions defined by a regular expression pattern. | Try it |
| Regex_SplitOp(input, pattern, replacement, options) | Splits an input string into an array of substrings at the positions defined by a regular expression pattern using the specified matching options. | Try it |