Share via


2.1.2.112 F844, SUBSTRING_REGEX function

V0148:

The specification states the following:

 Subclause 6.30, "<string value function>":
  
 <regex substring function> ::=
 SUBSTRING_REGEX <left paren>
 <XQuery pattern> [ FLAG <XQuery option flag> ]
 IN <regex subject string>
 [ FROM <start position> ]
 [ USING <char length units> ]
 [ OCCURRENCE <regex occurrence> ]
 [ GROUP <regex capture group> ]
 <right paren>
  
 ...
  
 Conformance Rules
  
 Without Feature F844, "SUBSTRING_REGEXP", conforming SQL language shall not contain <regex substring function>.

Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:

Transact-SQL does not support this feature.