Regular Expressions

How To Use Regular Expressions for Data Validation and Cleanup

  • Article

You need to provide data validation at the server level for complex strings like phone numbers, email addresses, etc. You may also need to do data cleanup / standardization before moving it from source to target. Although SQL Server provides a fair number of string functions, the code developed with these built-in functions can become complex and hard to maintain or reuse.

2011-03-03

15,100 reads

Blogs

Renewed as a Friend of Red Gate

By

I recently received the news that I’ve been renewed as a Friend of Red...

Redgate Software Needs You!

By

I’ve been very blessed to be able to work for Redgate Software. We’ve done...

Extended Events: Database Auditing

By

Extended Events can do things that simply are not possible with Profiler and another...

Read the latest Blogs

Forums

SSMA 8.6 Unable to find functions in extended stored procedures

By stonechain

I have an instance of SQL Server 2017 (Developer) installed with SSMA for Oracle...

Running generic query for table information

By sizal0234

Hi, I want to run the below query to get information about the tables...

Instance level trigger to store login information (who created what)

By Lord Slaagh

Hello SSC, I am looking for a simplified way to track which user created...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers