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
 Transact-SQL (2000)
 UDF for validating email addresses?

Author  Topic 

sherpa99
Starting Member

20 Posts

Posted - 2005-02-09 : 16:40:36
Does anyone have a user defined functions for validating email addresses?

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2005-02-09 : 16:48:32
you mean the correct format?

you could just use LIKE or PATINDEX

down and dirty:
Email like '%@%.%'

search for a past topic on this...



Corey

"If the only tool you have is a hammer, the whole world looks like a nail." - Mark Twain
Go to Top of Page

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2005-02-09 : 16:52:00
I found it for you:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=38724

Corey

"If the only tool you have is a hammer, the whole world looks like a nail." - Mark Twain
Go to Top of Page
   

- Advertisement -