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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-27 : 09:04:41
|
| Essa writes "Dear Sir;I want to validate Email addresses or URL addresses saved in SQL table using Transact SQL. I have done it in VB Script but I need SQL script. Regards,Muhammad Essa Mughal" |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-07-01 : 19:58:04
|
When you say validate - do you mean:1. you want to check that it looks like someone@someplace.somethingor 2. do you want to check that there is someone at the end of the email address?If you want #2 then you're a better man than me. If you want #1 you can do something like:[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=17143[/url] --I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
|
|
|
Email address or URL Validation using Transact SQL ?