MSSQL Data Validation Examples: Regular Expressions with LIKE Operator

This video walks you through 14 regular expression data validation test case examples. There are validation tests for phone numbers, social security numers, zip5 and/or zip9, text only, numeric only, no leading or trailing whitespace, only lowercase, only uppercase, titlecase, email addresses, and urls. Included also are two tips on web searches to support use of regular expressions: (1) search on “regular expression X” where X is the data element to validate (eg: phone number), and (2) search on “regular expression builder” (or tester) for excellent free tools that let you dial in a regular expression against text data all on a simple web page.

You can refactor and re-use the samples in your projects. The scripts in the demo are all out on Github along with 66 total sample validation tests along with a basic and an advanced script for automating the tests.

——- Chapter Timestamps (click to jump forward): —————————–
0:00 – Intro
0:07 – Introducing Rule Set #7 – Regular Expressions
10:46 – How to Download SQL Scripts in this Video
12:19 – The End

Downloads:
– Rule Set #7: https://github.com/DataResearchLabs/sql_scripts/blob/main/mssql/data_validation/rule_set_07__regular_expressions.md
– Multi-Platform Data Validation Scripts: https://github.com/DataResearchLabs/sql_scripts/blob/main/data_validation_scripts.md

Watch related playlist videos:
– https://www.youtube.com/playlist?list=PLVHoUDdbskUSlZTVZmllGTdSuvyI4LBiE

Connect with me on social media:
– LinkedIn: https://www.linkedin.com/in/mpiercead576/
– YouTube: https://www.youtube.com/channel/UCQciXv3xaBykeUFc04GxSXA
– GitHub: https://github.com/DataResearchLabs

Subscribe to my YouTube Channel:
– https://www.youtube.com/channel/UCQciXv3xaBykeUFc04GxSXA?sub_confirmation=1

Background Music (via YouTube “always free” Audio):
– “Rewind” by Ofshane: https://www.youtube.com/channel/UC34Wh4ysdP50H-ThbZFFfsA

#MSSQL #automation #datavalidation