Specifications
144 CHAPTER 7 Master Data Services
■
Mdq.RegexIsValid Indicates whether the regular expression is valid
■
Mdq.RegexMask Converts a set of regular expression option ags into a binary
value
■
Mdq.RegexMatches Finds all matches of a regular expression in an input string
■
Mdq.RegexReplace Replaces matches of a regular expression in an input string
with a different string
■
Mdq.RegexSplit Splits an input string into an array of strings based on the posi-
tions of a regular expression within the input string
■
Mdq.Similarity Returns a similarity score between two strings using a specied
matching algorithm
■
Mdq.SimilarityDate Returns a similarity score between two date values
■
Mdq.Split Splits an input string into an array of strings using specied characters as
a delimiter
NOTE For more information about the MDS functions, refer to the “Master Data
Services Functions (Transact-SQL)” topic in SQL Server 2008 R2 Books Online at
http://msdn.microsoft.com/en-us/library/ee633712(SQL.105).aspx.