SqlRegEx is a regular expression library embedded in SQL Server that can be accessed directly from SQL queries, functions and stored procedures. It enables SQL developers fast execution of regular expressions in the T-SQL language.

Features
SqlRegEx provides the following features:

• An expression data type (Expr), which allows a regular expression to be defined and stored.
• Expression modifiers to change the operation of the regular expression engine, including:
  • IgnoreCase / IgnoreCaseOff
  • Multiline / MultilineOff
  • Singline / SinglelineOff
  • IgnorePatternWhitespace / IgnorePatternWhitespaceOff
  • RightToLeft / RightToLeftOff
  • ExplicitCapture / ExplicitCaptureOff
  • ECMAScript / ECMAScriptOff
  • CultureInvariant / CultureInvariantOff
  • UseDbCulture / UseDbCultureOff
• Scalar functions:
  • IsMatch
  • Match
  • Replace
• Table valued functions:
  • Matches
  • Split
• A Match data type containing the result of a Match
• A Segment data type containing the result of a Split

Benefits

• Improve your productivity by using powerful text processing in your queries
• Solve common programming problems directly in the database
• Normalize the format of data fields by using regular expressions in update statements and data migration SQL
• Validate data using regular expression
• Improve performance by conducting complex searches through text documents in the database instead of passing large documents back to the business tier
• Split parameters which contain comma separated values using a single function call
• Split complex delimited data into parts to be processed