REGEXP_LIKE

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Returns true if the string matches the regular expression pattern.

  • <string>: The string to match against.
  • <pattern>: The regular expression pattern.

Returns a boolean value indicating whether the string matches the pattern.

  • Equivalent to the ~ operator but in function form.
  • Matches anywhere within the string by default. Use ^ and $ anchors for full string matching.
  • For detailed regex syntax, see Regular Expression Syntax.

Check whether a string matches a pattern.

Returns true.

Check whether a string contains digits.

Returns true.

Match the entire string using anchors.

Returns true.

Returns false because the entire string does not match.

Use in a WHERE clause to filter data.

Returns rows with valid email format.