Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Email Validation in existing Data.

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-07-15 : 08:22:36
MAyur writes "I have a table containg 5000 email. how do i check that they r the vaild email id's i mean their syntax is correct."

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2002-07-15 : 09:31:33
Step 1: determine your 'rules' for a valid email address.
Step 2: write queries to identitify offending records.

If you have a ruleset and need help forming the sql query, please provide the rule.

<O>
Go to Top of Page
   

- Advertisement -