Scripts

Technical Article

Validating different types of data like Gmail, Outlook email addresses, phone numbers, and URLs

Validating different types of data like Gmail, Outlook email addresses, phone numbers, and URLs in SQL can be a bit challenging since SQL is primarily used for data manipulation in databases and not for complex data validation. However, depending on the database system you are using, there might be some limited string manipulation functions available that can help you perform basic validation checks.

2.33 (3)

You rated this post out of 5. Change rating

2023-07-28

376 reads

Blogs

Speaking Engagements 2025

By

It’s been a minute since I’ve gotten out to speak at events, but the...

PASS Summit on Tour in New York City

By

The PASS Summit goes on tour this year, with an August stop in New...

SQL Server Errorlog: Not Just for Errors!

By

A Goldmine of Clues You Might Be Ignoring SQL Server’s Error Logs often get...

Read the latest Blogs

Forums

The Long Weekend

By Grant Fritchey

Comments posted to this topic are about the item The Long Weekend

Need Help to implement the De Duplication

By bala2014

Dear All, Good Day. I have a requirement to implement de-duplication on customer data...

Own Your Mistakes

By Grant Fritchey

Comments posted to this topic are about the item Own Your Mistakes

Visit the forum

Question of the Day

Independence Day

The film independence day was released in 1996. Which of these queries returns that year is run today?

See possible answers