SQL 2000 DBA Toolkit:RegExp (SQL Server Central)

SQL 2000 DBA Toolkit Part 2 Part 1 (SQL Server Central)

Regular Expression Tools
Regular expressions (regex's) are a precise notation for approximate matching. One of the most popular styles of regular expression syntax is the Perl syntax. The regular expression tools in the toolkit use the Boost::Regex++ library, which is compliant with Perl syntax. NOTE: Microsoft's regular expression syntax differs somewhat from Perl syntax, so .NET-specific regular expressions might require tweaking to use with these tools.

sql function & procedures:
fn_regex_match (@searchexpression, @searchstring, @options)
xp_regex_search (@searchexpression, @searchstring, @options)
xp_regex_split @searchexpression, @searchstring, @options
fn_regex_replace (@searchexpression, @searchstring, @replacement, @options)

Download the DBA Toolkit Here