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.

Contact Here

Azure Security Services

Keep in mind that SQL might not be the ideal choice for these types of validations, and you may need to consider using a programming language or tool that offers better support for data validation. However, I'll provide you with some basic examples of how you could attempt these validations in SQL. Please note that these examples may not cover all possible cases and may vary depending on the database system you are using.

SELECT email_address
FROM your_table
WHERE email_address LIKE '%@gmail.com';
SELECT email_address
FROM your_table
WHERE email_address LIKE '%@outlook.com' OR email_address LIKE '%@hotmail.com' OR email_address LIKE '%@live.com';
SELECT phone_number
FROM your_table
WHERE phone_number LIKE '[0-9]%';  -- Assuming the phone number starts with a digit
SELECT url
FROM your_table
WHERE url LIKE 'http://%' OR url LIKE 'https://%';

Rate

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2.33 (3)

You rated this post out of 5. Change rating

Share

Join the discussion and add your comment

Share

Rate

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2.33 (3)

You rated this post out of 5. Change rating

Related content

SQLServerCentral Article

The Basics of Cryptography Part 2

Encryption in SQL Server is difficult to implement and manage, but it is being required more and more often. However understanding what encryption means is as important as being able to manage and implement it. Michael Coles brings us part 2 in his series on explaining the mysteries behind cryptography.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2005-08-17

11,003 reads

SQLServerCentral Article

An Interview with Idera CEO, Rick Pleczko

I was talking with the people over at Idera a few weeks ago and they mentioned that their CEO would be happy to give us a few minutes of his time. So I took them up on the offer and built a list of questions about Idera and SQL Server 2005. Take a moment to learn about the vendor view of the world and the impending release of SQL Server 2005.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2005-03-15

6,097 reads