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

A simple Machine Learning process example (supervised) – just to start with

By

I have just written the fifth article of the Machine Learning topic. !!! This...

Always On: Troubleshooting Consolidated

By

Working on Always On and configuration/setup of AG we have observed many errors. especially...

Changing Git Credentials in Windows

By

tl;dr For Windows when you need a different account. I had to work with...

Read the latest Blogs

Forums

WhatsApp/Call:+1(859)740-9292"buy original ielts,pmp,gre,pte,pgmp,cisco Thailand

By Workbarron010

"WhatsApp/Call:+1(859)740-9292"buy original ielts,pmp,gre,pte,pgmp,cisco certificates in malaysia/Thailand

"Getcertified10@yahoo.com"buy ielts,pmp,gre,pte,pgmp,cisco certificates in Qatar

By Workbarron010

"Getcertified10@yahoo.com"buy ielts,pmp,gre,pte,pgmp,cisco certificates in hyderabad,Qatar

SSRS page number by a certain column grouping

By Siten0308

Hello, I have been givin a task and not sure how to handle this,...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers