regexp-function-descriptions.md

author	MikeRayMSFT
ms.author	mikeray
ms.reviewer	randolphwest
ms.date	05/05/2025
ms.service	sql
ms.topic	include
ms.custom	build-2025

Function	Description
REGEXP_LIKE	Returns a Boolean value that indicates whether the text input matches the regex pattern.
REGEXP_REPLACE	Returns a modified source string replaced by a replacement string, where occurrence of the regex pattern found.
REGEXP_SUBSTR	Extracts parts of a string based on a regular expression pattern. Returns Nth occurrence of a substring that matches the regex pattern.
REGEXP_INSTR	Returns the starting or ending position of the matched substring, depending on the option supplied.
REGEXP_COUNT	Returns a count of the number of times that regex pattern occurs in a string.
REGEXP_MATCHES	Returns a table of captured substring(s) that match a regular expression pattern to a string. If no match is found, the function returns no row.
REGEXP_SPLIT_TO_TABLE	Returns a table of strings split, delimited by the regex pattern. If there's no match to the pattern, the function returns the string.