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

State of Database DevOps Survey

By

Maybe you’re using DevOps within your database development and deployment. Maybe you’re not. Maybe...

HP is the 2019 Laptop Winner

By

This is for me, not necessarily for you, but I decided to go with...

Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 4

By

This is the fourth and final post in a series about modern Data Lake...

Read the latest Blogs

Forums

Snapshot Isolation and DMVs

By chris.o.smith

I recently noticed that DMVs, or at least sys.dm_db_partition_stats, does not respect snapshot isolation. ...

SSAS Remote Access

By Nick

Hi all, I've been using Power Pivot and Power BI for some time and...

Stored Procedure Documentation

By SQL Espo

I have developed several stored procedures that will be utilized by developers on a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers