By: Tim Smith
Summary
In this tutorial we looked at using regular expressions with alphabetic, numerical and special character data while looking at some applied examples where regular expressions may be a tool that we can use. We’ve also reviewed the inverse of regular expressions: expressions that look for data where it doesn’t fit a character type. From ETL to data parsing to identifying strict limits, whether we’re trying to identify data, or precisely limit data, we can use regular expressions if the situation calls for it.
Take the time to walk through each of the examples to get a better understanding of how you can use regular expressions when working with SQL Server using T-SQL.
