SQL Eval Function Regex_Index

Regex_Index returns the position in the original string where the first character of the captured substring is found.

Regex_Index (
	@input NVARCHAR (MAX),
	@pattern NVARCHAR (MAX)
	)
RETURNS INT

Parameters

  • input: The input string that contains the text to convert.
  • pattern: The regular expression pattern to match.

Returns

The zero-based index position in the original string where the first character of the captured substring is found or -1 if it is not.

Example

SELECT SQLNET::Regex_Index('An extraordinary day dawns with each new day.', '\be\w*\b')

Regex_Index4k

It is equivalent to Regex_Index except no NVARCHAR(MAX) parameters; it can be used when input data will never be over 4000 characters as this function offers better performance.

Regex_Index4k (
	@input NVARCHAR (4000),
	@pattern NVARCHAR (4000)
	)
RETURNS INT

Example

SELECT SQLNET::Regex_Index4k('An extraordinary day dawns with each new day.', '\be\w*\b')

Contents