This is the second part of my Regular Expression overview.  In the first article I discussed the basics of creating Regular Expressions and provided a link to test expression patterns using the .NET Framework RegEx classes.  In this article I will discuss the various actions that can be taken to match values in a string using regular expressions.  I will also discuss how you can implement a SQL CLR UDF to allow regular expression validation from your database to provide a strong level of input validation at the database level.

Read more...