Share via


2.1.2.113 F845, TRANSLATE_REGEX function

V0149:

The specification states the following:

 Subclause 6.30, "<string value function>":
  
 <regex transliteration> ::=
 TRANSLATE_REGEX <left paren>
 <XQuery pattern> [ FLAG <XQuery option flag> ]
 IN <regex subject string>
 [ WITH <XQuery replacement string> ]
 [ FROM <start position> ]
 [ USING <char length units> ]
 [ OCCURRENCE <regex transliteration occurrence> ]
 <left paren>
  
 ...
  
 Conformance Rules
  
 Without Feature F845, "TRANSLATE_REGEX", conforming SQL language shall not contain <regex transliteration>.

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

Transact-SQL does not support this feature.