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